when migrating from access to sql server do the AutoID numbers stay the same

[lala]

when migrating from access backend to the sql servier, do the AutoID numbers stay the same? or the numbers will be random autoid numbers in order?

for example, in access, if i was to append a table with AutoIDs into another table with autoids and actually append the autoid field - it'd accept the autoid numbers into the autoid field even though if i tried to type into that field i wouldn't be able to.

i'm probably going to be told right now that it was a bad practice to base some of my code on those numbers but it's too late. i was assuming that sql works in the same way access does and thought there'd be no harm in using them sometimes.

at this point if i had to go back and rewrite those pieces i'd be worried that i don't remember everywhere i used the autoid and be afraid that i'd miss some.

 

[MSAccessRookie]

when migrating from access backend to the sql servier, do the AutoID numbers stay the same? or the numbers will be random autoid numbers in order?

for example, in access, if i was to append a table with AutoIDs into another table with autoids and actually append the autoid field - it'd accept the autoid numbers into the autoid field even though if i tried to type into that field i wouldn't be able to.

i'm probably going to be told right now that it was a bad practice to base some of my code on those numbers but it's too late. i was assuming that sql works in the same way access does and thought there'd be no harm in using them sometimes.

at this point if i had to go back and rewrite those pieces i'd be worried that i don't remember everywhere i used the autoid and be afraid that i'd miss some.

You should have nothing to worry about regarding content, because the data itself will not change during the migration. After all, data is most often independent of its type. What you will need to do is make sure that the data TYPES are equivalent, so that future data will have the same properties as the present data does. If you are using the SQL Server Migration Assistant (aka SSMA), you should not have any issues in that area.

 

[lala]

You should have nothing to worry about regarding content, because the data itself will not change during the migration. After all, data is most often independent of its type. What you will need to do is make sure that the data TYPES are equivalent, so that future data will have the same properties as the present data does. If you are using the SQL Server Migration Assistant (aka SSMA), you should not have any issues in that area.

i guess i'm afraid because in my mind AutoID is not really data.

and i will try to use the migration tool however, last time i migrated to sql it gave me and error (don't remember what it said, not too informative). so i ended up migrating by hand.


ETA oops, forgot to say thank you)))))))))))))