Export (0) Print
Expand All

Upgrading an Existing Installation of SQL Server

SQL Server 2000

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.

Upgrading from SQL Server 7.0 to SQL Server 2000

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

SQL Setup

Upgrading Databases from SQL Server 7.0

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).

Upgrading from SQL Server 6.5 to SQL Server 2000

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.

SQL Server 6.0 to SQL Server 2000 (no direct upgrade)

To upgrade from SQL Server 6.0 to SQL Server 2000, you have two options:

  • Use the SQL Server Upgrade Wizard provided with SQL Server version 7.0 to upgrade from SQL Server 6.0 to SQL Server 7.0, and then use Setup to upgrade from SQL Server 7.0 to SQL Server 2000.

  • Convert the SQL Server 6.0 data to SQL Server 6.5, and then convert the SQL Server 6.5 data to SQL Server 2000.

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.

Version and Edition Upgrades

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 Edition1 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
SQL Server 2000 Enterprise Evaluation Edition2 SQL Server 2000 Personal Edition
SQL Server 2000 Standard Edition
SQL Server 2000 Enterprise Edition
SQL Server 2000 Developer Edition

  1. 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.

  2. When upgrading from SQL Server 2000 Enterprise Evaluation Edition, you cannot upgrade to a SQL Server 2000 failover cluster.

Upgrade options also depend on the operating system used. For more information, see Operating Systems Supported by the Editions of SQL Server 2000.

Upgrading Editions and Components within 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

SQL Setup

Adding Components to an instance of 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

SQL Setup

See Also

Upgrading to SQL Server 2000: Overview

Existing Installation Options

Select Components

Upgrading to a SQL Server 2000 Failover Cluster

Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft