How to: Upgrade to SQL Server 2005 with the Copy Database Wizard
This topic describes how to use the Copy Database Wizard to upgrade a SQL Server 2000 database to a SQL Server 2005 database.
When using the Copy Database Wizard to upgrade a database, adhere to the following requirements:
- Before upgrading, make sure that no applications or services are trying to access the database. Do not use read-only mode, as this will result in an error.
- You cannot rename the database during this operation.
To upgrade a SQL Server 2000 database to a SQL Server 2005 database
Connect to any instance of SQL Server Database Engine using Object Explorer in SQL Server Management Studio.
Expand Databases, right-click a database, point to Tasks, and then click Copy Database.
Complete the steps in the wizard.
To ensure optimal performance of an upgraded database, run
sp_updatestats(update statistics) against the upgraded database on the SQL Server 2005 server.