upgrading sql 6.5 to sql 2000

[cahelmster]

I need to migrate the databases off of an NT 4.0 box with SQL 6.5 to a new box with Windows 2000 and SQL 2000. Is there a specific method to accomplish this?

TIA!

----------------
Thanks!
CH

 

[RobertT687]

I can't remember if you can go directly from v6.5 to v2000 without first going to v7. The installation CD of v7 provides an upgrade utility that converts all tables and other objects. It's fairly straight forward. Just make sure you have sufficient disk space as the end product is a copy of both the 6.5 and 7.0 databases. The utility also provides a analysis utility that catches certain inconsistencies.

A couple of things I do remember that caused some problems.
Views are re-created in alphabetical order. Some may fail to create if they depend on other views that fall later in the alphabet. Those views need to be re-created manually.
If you have Crystal Reports installed on the same machine as SQL Server there are entries in the registry pointing to the Crystal Reports version of SQLSVR32.dll. The installation will fail until you edit the registry and change all references to point to the SQLSVR32.dll in the Windows directory.