Analyzing Results

Results from running a comparison between source and target tables are reported in the Verifier tab. You can use the Verifier Options dialog to specify the information that you want to see, but, by default, only records with differences are displayed.

In cases where the row appears in both the source and the target database, but one or more field values do not match, the source table row is displayed followed by the target table row. The differences are highlighted in the color selected for differences in the Options dialog (default is red), and you can scroll the rows to identify the fields with different values.
In cases where the row appears in the source table, but not in the target table, the row is displayed using the color selected for the source table in the Options dialog (default is blue.)
In cases where the row appears in the target table, but not in the source table, the row is displayed using the color selected for the target table in the Options dialog (default is yellow.)

The Details pane shows a text output summary of the verification operation that has been performed. It includes the following information. The contents of the Details pane can be saved using the Save Results button.

Comparing SAMPLES.DBM1 (18 records) to "TestCompare"."dbo".DBM1 (18 records)...

Results:

Number of records only on Source Table: 1

Number of records only on Target Table: 1

Number of different records: 3

It is also possible to set a Verifier Differences alert to send an email to a pre-configured address reporting the differences.