Upgrading an Existing Installation of SQL Server

SQL Server Setup Help

SQL Server Setup Help

Upgrading an Existing Installation of SQL Server

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