O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Upgrading SQL Server

As stated in Chapter 4, SQL Server 2000 gives you two different options for upgrading a server. The first option is to perform an actual upgrade of a SQL Server 7.0 database, which replaces the SQL Server 7.0 instance with SQL Server 2000 and upgrades the data files to SQL Server 2000. The second option is to leave SQL Server 7.0 intact and install a new instance of SQL Server 2000 alongside SQL Server 7.0. You can then use the Copy Database Wizard to upgrade databases from SQL Server 7.0 to SQL Server 2000.

For SQL Server 6.5, the upgrade process is done via the Version Upgrade Wizard. All the databases can be migrated at one time, or you can selectively upgrade them one at a time. The Version Upgrade Wizard provides a very ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required