How to upgrade databases online using the Copy Database Wizard (Enterprise Manager)

How to upgrade databases online using the Copy Database Wizard (Enterprise Manager)

To upgrade a SQL Server 7.0 database to a SQL Server 2000 database

1. Expand a server group, and then expand a server.
   
   
2. Right-click the server, point to All Tasks, and then click Copy Database Wizard.
   
   
3. Complete the steps in the wizard.

Important  After upgrading databases from SQL Server 7.0, run sp_updatestats (update statistics) against the database on the destination server to ensure optimal performance of the copied database.

See Also

Copy Database Wizard Help

Database Upgrade from SQL Server 7.0 (Copy Database Wizard)