Can any one suggest various ways of migrating a database from SQL server 2000 to 2005.
How do I make sure all constraints, primary keys and indexes are preserved. Is there any migration tool that preserves them.
migrationsql serversql-server-2005
Can any one suggest various ways of migrating a database from SQL server 2000 to 2005.
How do I make sure all constraints, primary keys and indexes are preserved. Is there any migration tool that preserves them.
Best Answer
There are several ways to do this, each of which carries all aspects of the database over to the new or upgraded server, the easiest of which are
I prefer the detach and attach method. Another thing to watch out for, specific to the databases themselves, is making sure that the logins get carried over to the new server. Use sp_help_revlogin to copy logins to the new server.