This topic has not yet been rated - Rate this topic

Switching Between SQL Server 6.5 and SQL Server 2000

SQL Server 2000

Microsoft® SQL Server™ 2000 can be installed on the same computer with Microsoft SQL Server version 6.5, but only one version can be active at one time. 

Note  Switching between versions is not the same as running multiple instances. For more information, see Working with Instances and Versions of SQL Server.

After the SQL Server Upgrade Wizard finishes the conversion from SQL Server version 6.5, SQL Server 2000 is the active version of SQL Server. If enough disk space exists on your computer, you can keep the SQL Server 6.5 installation intact.

To switch from one version to the other, use the Microsoft SQL Server-Switch application on the Start menu, or run Vswitch.exe.

Important  Be sure the SQL Server Upgrade Wizard is finished with its upgrade tasks, before you attempt to switch between the active and nonactive versions of SQL Server.

If you install a default instance of SQL Server 2000 on a computer running an instance of SQL Server 6.5, the default instance of SQL Server 2000 becomes the accessible instance of SQL Server, and the SQL Server 2000 program group appears on the Start menu. The instance of SQL Server 6.5 is switched out, and the SQL Server 6.5 program group does not appear on the Start menu.

You can run either the default instance of SQL Server 2000 or the instance of SQL Server 6.5, but not both at the same time. To switch between the two versions of SQL Server, use the Microsoft SQL Server-Verswitch entry on the Start menu. When you switch from SQL Server 2000 to SQL Server 6.5, the instance of SQL Server 2000 becomes inactive, and the SQL Server 6.5 program group replaces the SQL Server 2000 program group on the Start menu. When you switch from SQL Server 6.5 to SQL Server 2000, the process is reversed.

If you install one or more named instances of SQL Server 2000 on a computer running SQL Server 6.5 and there is no default instance of SQL Server 2000, the instance of SQL Server 6.5 remains active as the default instance. Both the SQL Server 2000 and SQL Server 6.5 program groups appear on the Start menu. You should use the SQL Server 6.5 tools to manage the default instance of SQL Server 6.5, and the SQL Server 2000 tools to manage the named instances of SQL Server 2000.

If you install both named and default instances of SQL Server 2000 on a computer running SQL Server 6.5, you can run the named instances of SQL Server 2000 at any time, but must version-switch between the default instance of SQL Server 2000 and the default instance of SQL Server 6.5. The SQL Server 2000 program group always appears on the Start menu. The SQL Server 6.5 program group appears on the Start menu whenever you have version switched to make SQL Server 6.5 the active default instance. The SQL Server 6.5 program group does not appear when you have version switched to make SQL Server 2000 the active default instance.

To switch from SQL Server 6.5 to SQL Server 2000

Command Prompt

Windows

See Also

Using SQL Server 6.5 with SQL Server 2000

Removing SQL Server 7.0 or SQL Server 6.5 After Upgrading

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.