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.
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.
Important: To ensure optimal performance of an upgraded database, run
sp_updatestats(update statistics) against the upgraded database on the SQL Server 2005 server.