What should I keep in mind when migrating from SQL Server 2000 to 2005?
Q: What are the things we should adhere while migrating from SQL server 2000 to SQL server 2005? Please list the procedure for the migration process.
James Delve says: There are good resources available on the web that cover this topic. Microsoft offers an option for you on their SQL Server solutions page. Also, you can download the SQL Server Upgrade Adviser here.
Decide on which upgrade method below to use and migrate an existing SQL Server 2000 database to SQL Server 2005:
Upgrade through Backup/Restore
Upgrade through Attach/Detach
Upgrade using Copy Database Wizard
Upgrade through an in-place install/upgrade
Technorati Tags:
SQL Server Upgrade Advisor, SQL Server, upgrade, backup/restore, database wizard