SQL Server 2005 Books Online (November 2008)
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

  1. Connect to any instance of SQL Server Database Engine using Object Explorer in SQL Server Management Studio.

  2. Expand Databases, right-click a database, point to Tasks, and then click Copy Database.

  3. Complete the steps in the wizard.

    ms190775.note(en-US,SQL.90).gifImportant:
    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)

Help and Information

Getting SQL Server 2005 Assistance
Tags :


Page view tracker