Upgrading to SQL Server 2000: Overview
Upgrading from Microsoft® SQL Server™ version 7.0 to Microsoft SQL Server 2000 is one of the basic choices offered by the SQL Server Setup program on the initial Installation Selection screen. When you select the option to Upgrade, remove, or add components to an existing installation of SQL Server, Setup detects your current installation and initiates the correct sequence of setup screens for the upgrade selected. Upgrade variations include:
- A complete installation upgrade from SQL Server 7.0 to SQL Server 2000 (installing over SQL Server 7.0).
- Adding components to an installation of SQL Server 2000.
- An upgrade to the feature set of an existing installation of SQL Server 2000 (edition and component upgrade).
- An upgrade to SQL Server 2000 from SQL Server version 6.5 using the SQL Server Upgrade Wizard.
- An online database upgrade of SQL Server 7.0 databases to SQL Server 2000 database format using the Copy Database Wizard.
During the upgrade from SQL Server 7.0, external packages, such as Microsoft Management Console and the Microsoft Distributed Transaction Coordinator, must be installed for each upgrade, and the registry updated. The master database and other system databases are upgraded in various ways involving a series of scripts run on the server with specific options. If the upgrade process fails built-in recovery mechanisms restart and resume the upgrade.