[dba-SQLServer] Access BE to SQL

not sure what you mean by resetting autonumbers but during the data
migration you can use identity_insert setting to the values from autonumber
field in access to an identity field in sql server.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_7zas.asp

also, if you find that it saves time, you might want to consider turning off
all foreign keys in the target db, import the data and then (crossing your
fingers) turn on the foreign key constraints using WITH CHECK (go look up
WITH CHECK and WITH NOCHECK for the alter constraint statement in books on
line
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_7zas.asp
);

hope that helps

Billy Pang
http://dbnotes.blogspot.com/
"Once the game is over, the King and the pawn go back in the same box." -
Italian proverb


On 10/5/06, Steve Capistrant <scapistrant at symphonyinfo.com> wrote:
>
>
> 1.  Migrate Data to SQL.  Resetting of autonumbers, referential integrity,
> some indexes.  332 instances @ 10 minutes = 55 hours
>
>
> --
>