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.
Procedure
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.
Important
To ensure optimal performance of an upgraded database, run
sp_updatestats(update statistics) against the upgraded database on the SQL Server 2005 server.
See Also
Concepts
Using the Copy Database Wizard
Copying Databases from SQL Server 6.5 or Earlier
How to: Upgrade a Database Using Detach and Attach (Transact-SQL)