Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)
You can convert data from Microsoft® SQL Server™ version 6.5 to the formats for SQL Server 2000 using the SQL Server Upgrade Wizard. The wizard upgrades any or all of your databases, transferring all catalog data, objects, and user data. It also transfers replication settings, SQL Executive settings, and most of the SQL Server 6.5 configuration options. Be sure to review all aspects of this upgrade, as noted in Preparing to Upgrade from SQL Server 6.5.
Note To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server 2000 installed on your computer.
The SQL Server Upgrade Wizard does not support consolidation of databases from multiple SQL Server 6.5 installations. If you must upgrade SQL Server 6.5 databases from multiple servers, consolidate all of the SQL Server 6.5 databases onto one server, and then run the wizard to upgrade the consolidated server.
The SQL Server Upgrade Wizard does not remove SQL Server 6.5 from your computer. If you are using a tape backup to perform the upgrade, you have the option of removing the SQL Server 6.5 devices to save disk space.
When the upgrade process is complete, two separate installations of SQL Server exist, including two separate sets of the same data. The SQL Server 6.5 and the SQL Server 2000 installations become independent of each other.
If you are performing the upgrade on a single computer, additional disk space is required. For more information, see Estimating the Disk Space Required for Upgrading. You can also upgrade from one computer to another. For more information, see Upgrading Using One or Two Computers (Logon Screen).
Note You can leave the installation of SQL Server 6.5 on a computer indefinitely. In addition to installations of SQL Server 6.5 and a default instance of SQL Server 2000 on the same computer, you also can install multiple named instances of the SQL Server 2000 on the same computer. For more information, see Working with Instances and Versions of SQL Server.
To perform a version upgrade using a direct pipeline