Access 2000 to SQL server migration help 1

[maxf]

I'm trying to find the easiest/quickest way to migrate a db (the db structure--primary keys, column types-- and data) from Access to SQL server. Can anyone recommend a good post or article which details an easy/quick method?

 

[onpnt]

data transfer services will do most of the work for you. simply open enterprise manager. expand to the databases directory. right click and create a new database. after that is done, right click the new database and select all tasks --> Import data. follow the wizard and select copy tables and views. after taht is done about the only thing to do is go in a set your primary (if autonumber in access) to identity = yes along with the seed and increment you want to match the access properties for the primary ID. you may need to make small adjustments to data type but in most cases they are accurate.

_____________________________________________________________________

_{Hakuna matata!!}

 

[maxf]

that did it.

thanks

 

[saunan]

What if I don't have Enterprise Manager? I'm using MSDE and the Access 2002 Upsizing Wizard isn't supported by the vendor an ASP application I use.