Access 2000/2002 to SQL server

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.
Danijel Novak
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:43DCD052.D0C262F3@.softdelirium.qc.ca...
> Hi everyones,
> Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005?
> thank you
> serge
>
|||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.
Jan D''Hondt
Jade bvba
Belgium
Database and .NET development
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
"Serge Myrand" wrote:

> Hi everyones,
> Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005?
> thank you
> serge
>
sql