The following questions are intended to
Microsoft SQL Server 7 provides the ability to upgrade a complete SQL Server 6.
installation to SQL Server 7. In this chapter, you will learn how to use the SQL Server Upgrade Wizard and how to perform other
This chapter provides a theoretical explanation of the upgrade process. There are no prerequisites for completing the lessons in this chapter.
As part of your upgrade plan, you should analyze the software requirements and address any upgrade considerations. You must also perform certain
After this lesson, you will be able to
- Describe the upgrade process
- Identify and address potential issues before upgrading a database
Estimated lesson time: 15 minutes
The SQL Server Upgrade Wizard automates the process of upgrading SQL Server 6.
databases to SQL Server 7. You can use other tools such as Data Transformation Services or the bcp
The SQL Server Upgrade Wizard can transfer schema, objects, and data as well as logins and database users. It also transfers replication settings, SQL Executive settings (called SQL Server Agent in SQL Server 7), and many SQL Server 6. x configuration options.
The SQL Server Upgrade Wizard does not remove SQL Server 6. x from the computer. After upgrading, you will have two installations of SQL Server and two sets of data. SQL Server 6. x and SQL Server 7 installations are completely separate and independent. You should leave SQL Server 6. x on the computer until you verify the success of the upgrade. Optionally, you can remove SQL Server 6. x devices to save disk space if you use the tape upgrade option.
To switch from one version of SQL Server to the other, use the Microsoft SQL Server-Switch application on the Start menu, or run Vswitch.exe in the C:\Mssql7\Binn directory.
Do not switch versions while the Upgrade Wizard is running, as this can cause the upgrade to fail.
Before running the SQL Server Upgrade Wizard, you should consider these upgrade issues:
In order to upgrade a SQL Server 6. x database, the SQL Server computer must have the following software installed:
The SQL Server 6.5 and SQL Server 7 installations must have Named Pipes installed as a network library, even if you are using the tape upgrade option. Both SQL Server 6. x and SQL Server 7 must listen on the default pipe, \\.\pipe\sql\query.
You can upgrade only SQL Server 6. x databases to SQL Server 7. You cannot upgrade SQL Server 4.2 software or databases directly to SQL Server 7. Instead, you must upgrade the SQL Server 4.2 software and databases to SQL Server 6.5 and then upgrade to SQL Server 7.
In addition to the hard disk space used by SQL Server 7, you should have free disk space amounting to approximately 1.5 times the space used by the existing SQL Server 6. x databases.
You can use the SQL Server Upgrade Wizard to estimate the disk space needed to upgrade the SQL Server 6. x server to SQL Server 7. The wizard can estimate the following space requirements:
The space requirement figures that the Upgrade Wizard provides are estimates, not exact sizes.
When upgrading enterprise servers involved in replication, you must upgrade the Distributor before you upgrade any other servers. You can phase in the conversion of the servers in your replication topology by upgrading the Distributor first and then upgrading other servers as time and resources permit.
You cannot use many of the new replication features until you have upgraded all of the servers involved in your replication topology.
After you install SQL Server 7, and before you use the SQL Server Upgrade Wizard, you must perform the following tasks:
SQL Server 7 has many features designed to make it as easy as possible to upgrade from earlier versions. The SQL Server Upgrade Wizard allows you to upgrade from SQL Server 6.
with minimum work. The process uses the new SQL Server 7 installation and the old SQL Server 6.
installation to copy across all of the old databases and database objects that you select. The process includes the ability to switch back to the old version on the same machine. The upgrade should proceed cleanly if you prepare