Hey, hopefully this is the right place to post this - wasn't really sure.
I'm trying to move a relatively large database from an old server to a new one. I've tried using the data import tool and I've tried copying the mdf files directly over to the new server and attaching the database and in both scenarios the ID columns
that were marked as identity columns lose their Identity Specification settings.
The old server is running SQL Server 2008 and the new server is running SQL Server 2008 R2.
Can anyone advise me on remedying this problem or tell me what I'm doing wrong?
View Complete Post