I want to migrate 2 database from my old SQL Server 2000 to my new server with the 2008 version.
I do that with the Management Studio 2008 with the export data task. It works fine and no error occurs but in the database on my new server all primary keys are missing.
Did anyone knows why or has another idea how to solve my problem.
When you get to the Select Source Tables and Views step of the export wizard you need to do Edit Mapping for each selection, then select Enable Identity Insert. If you don't check this option the primary key values are not exported.