Export (0) Print
Expand All

How To Upgrade from SQL Server 6.5

SQL Server 2000

The How To topics in this section are specific to the process of converting data from Microsoft® SQL Server™ 6.5 to Microsoft SQL Server 2000 using the SQL Server Upgrade Wizard.

Note  To run the SQL Server Upgrade Wizard, you must have an instance of Microsoft SQL Server 2000 already installed on your computer.

Considerations when upgrading from SQL Server 6.5:
  • During the upgrade process, the SQL Server 6.5 server is stopped and started while objects are scripted and data is extracted. When the data transfer starts, only SQL Server 2000 is running, and it is not possible to access SQL Server 6.5.

  • If you are upgrading your existing SQL Server 6.5 server to a different computer that is running SQL Server 2000, both computers should be configured to use a domain user name and password for the MSSQLServer service.

  • During this upgrade, user-defined messages created in SQL Server 6.5 using sp_addmessage are not converted to SQL Server 2000. To retain these custom messages, manually copy the messages added in SQL Server 6.5 to your installation of SQL Server 2000.

See Also

Troubleshooting the SQL Server Upgrade Wizard

Completing the SQL Server Upgrade Wizard

Upgrade Log Files

Upgrading to SQL Server 2000 FAQ

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