When using the Data Transformation Services to transfer the data in one
database to a new database, the incrementer and primary key identities are
lost! If you do a direct copy of the tables between the databases, the ID
and primary key relationships do not carry over. Also if you use the SQL
transfer option, it crashes before transferring any data. The only way I
have found that is successful is to backup and restore the database. I was
hoping for a better solution. PLEASE HELP!