How To Upgrade from SQL Server 6.5
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.