Verifier Options Dialog

Use the Verifier Options dialog to determine the number of rows to process and display, and to customize the way that source and target tables are compared. If you make changes to settings in this dialog, they only apply to activity in the current Verifier tab. To retain the settings for all Verifier actions, click Apply Settings to Metadata in the dialog. These settings will then also be available in the Preferences tab of the Replication Properties dialog.

General Tab
Comparison Tab
Data Types Tab
Conditions Section

Reconcile Tab

General Tab

Run Verification Automatically

Unchecked by default. Start the verification process using the Run Verification button on the Verifier tab. Check this option if you want to start the verification process automatically in the Verifier tab when you select a replication in the Metadata Explorer, and choose Verify Replication from the right mouse button menu.

Show Source and Target Table in the Grid

Checked by default. When checked, the source and target table contents are displayed in the Verifier tab for easy comparison of rows. However, if you know that your table contains large amounts of data, you may want to view only the summary in the Details pane in the Verifier.

Max Number of Comparisons

Unchecked by default. This option allows you to control the maximum number of records to compare. When checked, the default is set to 10,000. The default value can be managed in the Replication Properties dialog.

Max Rows to Manage in Grid

The default value is 10,000. This is the total number of rows to retrieve/view in the Verifier. This number can be modified in accordance with the memory and CPU configuration of your computer.

Show Differences Only

Checked by Default. This option allows you to control if all records in the source and target tables are displayed in the Verifier tab, or only those records that contain differences. Uncheck the option to display all records.

Colors

Use these three fields to select colors to be used for source table rows, target table rows and conflicts found during the comparison process.

Comparison Tab

Verify Primary Key Only

Unchecked by default. When checked, the Verifier compares only the primary key field value(s) in source and target tables to determine differences between the tables. Note that Reconcile Data is not enabled when Verify Primary Key Only has been selected because differences and column data are not recorded during the operation to compare primary keys only.

Verify With Pivot Columns

Unchecked by default. When checked, select a column name (must be a Date, Time or Timestamp type) to use in filtering the rows to be verified. This can be used to reduce the number of records verified. For example, if a Timestamp column is specified, a where condition is created in the verification to extract the rows on source and target that were changed after the most recent timestamp.

Verify Subset of Columns

Unchecked by default. When checked, select one or more column names to use in filtering the rows to be verified. Primary keys are included in the selected columns by default. This can be used to reduce the number of records verified.

Data Types Tab

Record Count Only

Unchecked by default. When checked, the verification process compares only the number of records in the source and target tables.

Skip/Ignore BLOB/CLOB

Unchecked by default. Any BLOB/CLOB field values will be included when comparing source and target tables. This option is unchecked by default, but comparing BLOB/CLOB values can be very time consuming so you may want to change the setting.

Skip/Ignore Array of Bytes

Unchecked by default. Any Byte Array field values will be included when comparing source and target tables.

Trim Chars

Checked by default. This option provides a way for the tool to ignore blank characters in string values. Some databases set string values at a fixed length using blank spaces to fill the string, while others permit strings of different lengths. If you check this option, the tool trims all strings with fixed string length, then compares the strings.

Skip/Ignore Date Time

When selected, any Date Time field values will be ignored when comparing source and target tables. This is because databases may store these values in different formats, so a verification might show a difference where there is no difference in the actual value, just the format in which it is stored.

Skip/Ignore Time

When selected, any Time field values will be ignored when comparing source and target tables. This is because databases may store these values in different formats, so a comparison might show a difference where there is no difference in the actual value, just the format in which it is stored.

Number of Fractional Digits

Selected by default, with the value 0. Specifically for time values, this option allows you to determine how many digits to the right of the decimal point you wish to use in comparing field values.

Conditions

WHERE Condition

Provides fields for both source and target tables to type in a condition to narrow the number of rows compared and reported. Type the SQL syntax that you would use following the "WHERE" condition in a SQL statement.

ORDER BY Clause

The default ORDER BY clause in the Verifier is to order by primary key. However, this can be problematic when the primary key is a string because database providers can order strings differently. This field allows you to override the default ORDER BY clause by typing a single column name, or a list of comma-separated column names.

Reconcile Tab

By default, all inserts, updates and deletes are reconciled. On this tab you can check/uncheck Insert, Update and/or Delete operations.

Apply Settings to Metadata Button

Click this button to save these settings for future verification activities. Settings are saved and visible in the Replication Properties Verifier tab.

Opening the Verifier Options Dialog

In the Metadata Explorer, select a replication.
From the right mouse button menu, choose Verify Replication.
In the Verifier tab toolbar, click Options.