Considerations for upgrading SQL SERVER 6.5 to 2000

Server
SQL SERVER2000 provides an upgrade wizard to facilitate the database upgrade conversion process for SQL SERVER version 6.5 users to be secure without losing data. Use the Upgrade Wizard to convert one or all system data, user data, database objects, and even upgrade the tasks and configurations of databases such as replication settings.

Note:

1. Before upgrading, you must have a default instance of SQL SERVER 2000 installed on your computer.

2. Back up all databases, including Master, before upgrading.

3. Run DBCC to ensure that the original SQL SERVER6.5 data is consistent across all data.

4, estimate the size of the disk space to upgrade the data.

5, to ensure that the master database has at least 3 m space.

6. Set SQL SERVER 6.5 's tempdb database space at least 10M, and the recommended space is 25M.

7. Turn off all stored procedures that run when SQL SERVER 6.5 starts.

8. Turn off the Replication service for SQL SERVER 6.5.

9. Turn off all services and services that are run by SQL Server.

10, to ensure that there are cross data of the difference between the database has been upgraded.

11, to ensure that the existing database users on the master database has the appropriate registration information.

12, change the original referenced SQL Server 6.5 server name in the master database to SQL Server 2000.

13. When you run the upgrade program, the Upgrade Wizard does not remove SQL Server 6.5 from your computer, and users can still use the original SQL Server 6.5 as usual.