BOL - Installing SQL Server - Upgrading an Existing Installation of SQL Server

"How to upgrade a SQL Server 7.0 installation to SQL Server 2000 (Setup)


Caution This version upgrade procedure overwrites your Microsoft® SQL Server™ 7.0 installation; the installation no longer exists on your computer. In addition, previous registry settings are removed. For example, after upgrading you will need to re-register your servers.

To restore the SQL Server 7.0 installation, you must first uninstall SQL Server 2000, perform a complete reinstall of the SQL Server 7.0 files, and then restore your backed-up SQL Server 7.0 databases.


To upgrade SQL Server 7.0 to SQL Server 2000

1. Insert the Microsoft SQL Server 2000 compact disc for the edition to which you want to upgrade into your CD-ROM drive. If the compact disc does not autorun, double-click Autorun.exe in the root directory of the compact disc.


!Note If you have purchased an edition of SQL Server with more features than your current SQL Server 7.0 installation, the upgrade process will perform both the version and edition upgrade at the same time.


2. Select SQL Server 2000 Components, select Install Database Server, and then setup prepares the SQL Server Installation Wizard. At the Welcome screen, click Next.


3. In Computer Name dialog box, Local Computer is the default option and the local computer name appears in the edit box. Click Next.


4. In the Installation Selection dialog box, click Upgrade, remove, or add components to an existing instance of SQL Server, and then click Next.


5. In the Instance Name dialog box, Default will be selected. Click Next.

!Note When upgrading, SQL Server 7.0 automatically becomes the default instance of SQL Server 2000.


6. In the Existing Installation dialog box, click Upgrade your existing installation, and then click Next.


7. In the Upgrade dialog box, you are prompted as to whether you want to proceed with the requested upgrade. Click Yes, upgrade my <text specific to the upgrade> to start the upgrade process, and then click Next. The upgrade runs until finished.


8. In the Connect to Server dialog box, select an authentication mode, and then click Next.
If you are not sure which mode to use, accept the default: The Windows account information I use to log on to my computer with (Windows).


9. In Start Copying Files dialog box, click Next.


0. In the Setup Complete dialog box, click Yes, I want to restart my computer now, and then click Finish.
"

Какую версию на какую версию вы хотите апгрэйдить ?

Понятно что с 7 на 2000\
Edition-ы какие ?

SQL Server 7.0 Standard Edition можно апгрэйдить только до SQL Server 2000 Standard Edition или до SQL Server 2000 Enterprise Edition