The transfer of objects and data by the SQL Server Upgrade Wizard is a very reliable process. If any objects could not be imported due to errors in those objects or compatibility problems with Microsoft® SQL Server™ version 7.0, they are noted in the output logs of the SQL Server Upgrade Wizard.
The SQL Server Upgrade Wizard also offers the following optional verification measures:
The SQL Server Upgrade Wizard examines the SQL Server 6.x databases before the upgrade process and the SQL Server 7.0 databases after the upgrade. For each, the wizard prepares a list of all objects, including schema and stored procedures, and the number of rows in each table. It then compares the two lists and reports any discrepancies.
The SQL Server Upgrade Wizard performs a checksum for each column of each table before and after the upgrade to verify that data values have not changed.
Note The SQL Server Upgrade Wizard does not report as errors any differences in objects that are there by design. If some objects, typically stored procedures, could not import due to errors in the objects or compatibility problems with SQL Server 7.0, they are reported twice: once in the SQL scripts that show the source code of the objects and the error messages received from SQL Server 7.0 when trying to create them, and then again in the output of the verification processes.