Hi everyones,

Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005?

thank you
serge

Hi,

You can use DTS to import all the data and create database.
Of course you'll have to setup security afterwards.

Show quoteHide quote

Apart from the dts package, You can use other methods as well:

From within ms-access : open database and go to Tools / Database utilities /
upsizing wizard
this wizard will generate a sql server database for you. You may have to do
some cleaning up in the sql database afterwards;

From SQL 2005 Management studio: connect to the sql server, in object
explorer rightclick on 'management' and choose import data. This opens the
import data wizard wich will create some sort of DTS package for you. I
personally have not tried this yet on sql 2005.

ON SQL 2000 enterprise manager there is a similar import data wizard.

From my own experience the Access wizard makes a more thorough conversion
(with primary keys and foreign keys added to the tables)
You may have to try different approaches on a test SQL server to find the
best result.

Show quoteHide quote

SSMS Query Editor... Vs Query Analyser
DTS Designer error
MS Reporting, Oracle
Why is SQL Server 2005 Management Studio so slow?
SQL Server Remote Access Tool