You can upgrade from earlier versions to Microsoft® SQL Server™ 2000, and also perform upgrade operations once SQL Server 2000 is installed. Upgrades to SQL Server 2000 from SQL Server version 6.5 and from SQL Server version 7.0 are different operations. SQL Server 6.5 databases (and related information) are converted to SQL Server 2000 formats. An installation of SQL Server 7.0 is overwritten by SQL Server 2000, unless a named instance configuration is installed, allowing SQL Server 7.0 to remain intact.
After an initial installation of SQL Server 2000, other upgrade options are available. If using more than one instance of SQL Server 2000, you can upgrade one instance by adding components, and have different component sets for multiple instances.
You can overwrite your existing installation of SQL Server 7.0 by installing a default instance of SQL Server 2000. You can also keep your installation of SQL Server 7.0 intact by installing a named instance of SQL Server 2000. Both operations are performed using the following procedure.
To upgrade from SQL Server 7.0 to SQL Server 2000
Instead of a full upgrade from SQL Server 7.0 to SQL Server 2000, which overwrites SQL Server 7.0, you can upgrade SQL Server 7.0 databases and associated meta data. For more information, see Upgrading Databases from SQL Server 7.0 (Copy Database Wizard).
After installing Microsoft® SQL Server™ 2000, you can upgrade your SQL Server version 6.5 server configuration and databases using the SQL Server Upgrade Wizard. In this process, SQL Server 6.5 information and data is transferred to a SQL Server 2000 installation. The SQL Server 6.5 installation remains intact on the computer. It can be removed, or kept on the computer and used in a version switch configuration with SQL Server 2000.
Note If you plan to keep SQL Server 6.5 installed alongside an instance of SQL Server 2000 (for version switching purposes), SQL Server Service Pack (SP5) must be applied to SQL Server 6.5 before installing SQL Server 2000.
To upgrade from SQL Server 6.0 to SQL Server 2000, you have two options:
Note Both data conversions are performed using the SQL Server Upgrade Wizard, although different versions of the Upgrade Wizard are used. The SQL Server 7.0 Upgrade Wizard can upgrade SQL Server 6.0 or SQL Server 6.5 databases to SQL Server 7.0 databases. In SQL Server 2000, the Upgrade Wizard is used only for upgrades from SQL Server 6.5 to SQL Server 2000.
Each of the editions of Microsoft® SQL Server™ 2000 (SQL Server 2000 Enterprise Edition, SQL Server 2000 Standard Edition, SQL Server 2000 Personal Edition, and SQL Server 2000 Developer Edition) comes with its own compact disc and is installed separately.
You can add to the feature set of your installation of Microsoft SQL Server by performing a version and edition upgrade at the same time. For example, if you have purchased Microsoft SQL Server 2000 Standard Edition, you can upgrade from SQL Server 7.0 Desktop Edition to SQL Server 2000 Standard Edition.
Upgrade options between versions and editions of SQL Server are shown in the table.
| Installed Version | Can upgrade to |
|---|---|
| SQL Server 7.0 Desktop Edition | SQL Server 2000 Personal Edition SQL Server 2000 Standard Edition |
| SQL Server 7.0 Standard Edition | SQL Server 2000 Standard Edition SQL Server 2000 Enterprise Edition |
| SQL Server 7.0 Enterprise Edition | SQL Server 2000 Enterprise Edition |
| SQL Server 2000 Developer Edition | SQL Server 2000 Enterprise Edition |
| SQL Server 2000 Standard Edition | SQL Server 2000 Enterprise Edition |
| SQL Server 2000 Personal Edition | SQL Server 2000 Standard Edition |
Note SQL Server 7.0 Desktop Edition has been replaced by the SQL Server 2000 Personal Edition; however, you can still perform this type of version and edition upgrade.
Upgrade options also depend on the operating system used. For more information, see Operating Systems Supported by the Editions of SQL Server 2000.
You can add functionality while upgrading from one edition of SQL Server 2000 to another, and have the option to add components during this upgrade. For example, if you upgrade from the SQL Server 2000 Personal Edition to the SQL Server 2000 Standard Edition, you can install additional components during the upgrade process.
To perform an edition upgrade within SQL Server 2000
You can add components to an existing installation of SQL Server 2000 by selecting the instance of SQL Server to which you want to add features. This method allows you to have different component sets for the default instance and for any named instances.
To add components to an instance of SQL Server 2000
Upgrading to SQL Server 2000: Overview