Previous Thread

7/15/2006 4:48:22 PM    Insert Into Identity
If my SQL 2005 table has identity field and I want to import my Access table 
 
with an autonumber field, will it retain the numbers from the autonumber 
 
field from the Access table and then RESEED the starting identity in the SQL 
 
table using SSMA?  Thanks. 
 
David



7/15/2006 5:00:35 PM    Re: Insert Into Identity
Go to tools->Project setting ->Migration 
 
and make sure that the 'keep identity' option is set to true. Then you have 
 
the affect you described. 
 
"David Chase" <dlchase@lifetimeinc.com> wrote in message 
 
news:ubIINjFqGHA.4812@TK2MSFTNGP04.phx.gbl...