Selecting Databases to Upgrade

Installing SQL Server

Installing SQL Server

Selecting Databases to Upgrade

When running the SQL Server Upgrade Wizard, you can choose to upgrade some or all Microsoft® SQL Server™ version 6.5 databases. The master, msdb, and publication system databases, as well as the pubs and Northwind sample databases, are not explicitly available for selection. However, the master, msdb, and publication databases can be selected for upgrading (the default) in the Server Configuration dialog box of the SQL Server Upgrade Wizard.

Note  If you run the SQL Server Upgrade Wizard again after databases have been upgraded, previously updated databases will default to the excluded list. If you want to upgrade a database again, drop the database in SQL Server 2000 and move it to the included list in the wizard.