I did an export of data from 2000 to 2008, all the tables and data copied
over with the exception of the Identity attribute. (which is the auto number
This is not good, I tried to manually do it and it says that I need to drop
and recreate table. This poses an issue given all data I have in the table
and that needs to be imported over.
Within SQL 2008 SQL Server Management Studio, I did a right click on the
database and Tasks, then either Import or Export works to bring the stuff
over...but the Identity attribute does not carry over.