Data Migration Report (Db2ToSQL)

The Data Migration Report dialog box appears after you migrate data to SQL Server, using SQL Server Migration Assistant (SSMA).

Options

Status

Shows the status of the data migration from the source to the target database.

From

The source table.

To

The target table.

Total Number of Rows

The number of rows of data in the source table.

Number of Successfully Migrated Rows

The number of rows of data successfully migrated to the target table.

Ratio

The percentage of rows successfully migrated.

Details

If any data migration failed, select to display migration details for the selected row in the report. SSMA displays the reason for the failure.

Save Report

Saves the report to a .csv (comma-separated values) file, which can be examined using Microsoft Excel.