Troubleshooting the SQL Server Upgrade Wizard

The SQL Server Upgrade Wizard is designed to be as problem free as possible; however, there are situations that may interfere with upgrading Microsoft SQL Server version 6.x databases to SQL Server 7.0. The most common upgrade error is the failure to create an object in SQL Server 7.0. In many cases, the problem is simple, such as running out of disk space. In any case, the SQL Server Upgrade Wizard creates detailed logs specifying the problem.

Completing the SQL Server Upgrade Wizard

The SQL Server Upgrade Wizard performs a version upgrade using the options you specified. The Microsoft SQL Server version 6.x server and data are left intact throughout the version upgrade process.

During the SQL Server Upgrade Wizard process:

If the SQL Server Upgrade Wizard detects any problems, a dialog box is displayed with this text:

One or more warnings have been logged. Please read the next screen carefully before you begin your upgrade.

The Summary of Warnings dialog box displays inconsistencies found in the user objects of accounts. Users should not continue until these are resolved. This output file is located in the \Mssql\Upgrade\<SQLServer_date_time> directory. The file name is associated with the database name and ID, "check65-<dbid><dbname>_err.out" (for example, "check65-007mypubs_err.out"). If the user continues without fixing the listed errors, check the relevant files for objects, logins, and invalid permissions.

If stored procedures have been renamed using sp_rename, the source stored in syscomments must be changed. Drop and re-create the procedure using the new name in the CREATE PROCEDURE syntax.

Upgrade Log Files

Each time you run the SQL Server Upgrade Wizard, a subdirectory is created in the C:\Mssql7\Upgrade directory. The subdirectory name consists of the server name and the current date and time to distinguish multiple runs of the SQL Server Upgrade Wizard (for example, SQLCONV1_092198_151900).

Inside this subdirectory are a number of descriptively named log files describing each of the upgrade steps. Also inside is another subdirectory for each upgraded database, including the master database. Inside each database folder are log files indicating the success of the creation of different types of objects in that database. Files that end in .ok indicate that all instances of that type of object were created successfully. Files that end in .err indicate that at least one instance of that type of object was not created successfully. The error files list each failed object creation statement and the reason the object was not created successfully.

Any log files that indicate a problem are listed at the end of the SQL Server Upgrade Wizard for easy access.