Hi Guys,

I was wondering if anyone can help in this :

I trying to convert the access database to SQL server 2000 using microsoft tool - Upsizing wizard.

Does anyone what are the steps involved in order to do so?

Any help is appreciated....

Thanks,
Haseeb

Hi,

   It depends a little on how well developed the database is to start with.

   Generally you will want the rights to create a database on the SQL Server, if one is not already created. When you start the wizard, it will ask where you want to upsize to (New or Existing database). Then it will move the tables to the SQL Server, and attempt to modify any code that refers directly to the tables.

   It will also ask you if you want to create an Access database (.mdb), or an Access data project (.adp). These extensions are different for Office 2007. The type is your preference. I personally don't use the projects since I have SQL Server Enterprise Manager and Query Analyzer on my desktop.

   Some actions may not work and will have to be rewritten to work with SQL Server.

   Try this out on the Northwind database (there should be a northwind on the sql server, so create a new database there) and you will see how that works.

Did any of that help?



mmcdonal

Look it up at: http://wrox.books24x7.com