Verifier

The Verifier tool can be used to verify replication results and reconcile data differences for replications that have been created and run in Syniti Data Replication. It allows you to check for differences between source and target tables and therefore helps with troubleshooting replication problems during your replication setup and implementation phase.

The Verifier tab consists of three panes:

Source Table
Displays the source table in the replication under verification.

Target Table
Displays the target table in the replication under verification.

Details
Displays a text summary of the verification process.

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 icon bar offers the following actions.

	Run Verification Compares source and target table to identify differences. Reports the results in table format and as text in the Details area of the tab.
	Stop Halts the verification process. This is useful if verification is taking longer than expected.
	Reconcile Data After confirmation, modifies the target table to match the source table based on information gathered during the verification process. By default, all inserts, updates and deletes are reconciled. However, if you click and hold over the arrow to the right of the icon, you can deselect the items that you do not want to reconcile.
	Save Results Saves information about table differences and messages displayed in the Details section of the tab to a text file.
	Options Displays the Verifier Options dialog, allowing you to set a range of options to control how the verification is run.

Scheduling Verifier Activity

During operation, the Verifier accesses both the source and target tables, and on request also reconciles any mismatched data. This process can impact daily operations on production databases so Syniti DR provides an option to schedule verification. The schedule is set in the Replication Properties dialog and uses a Windows service called Verifier Scheduler. To schedule verifications:

Select the replication in the Metadata Explorer.
From the right mouse button, choose Replication Properties.
In the Replication Properties dialog, go to the Scheduler page.
On the Scheduler page, choose the Verifier Schedule tab.
Click the option Run Recurrently.
Check the Reconcile Data checkbox if you would like Syniti DR to modify source and/or target tables when needed.
Click Add to open the Scheduler dialog.
Set the frequency in the Scheduler dialog.
Click OK to close the Scheduler dialog.
Click OK to close the Replication Properties dialog.
In the Windows Notification Area, right click on the Service Monitor .
From the menu, choose Verifier Scheduler, then Start, then Service.

When the Verifier Scheduler is in use, a log file and history file named with the prefix "DBMotoVS" are automatically generated to enable you to track activity. The information can be viewed from the Log Viewer or History Viewer.

Opening the Verifier

In the Management Center Metadata Explorer, Replication Browser, or Replication Monitor, select a replication and, from the right mouse button menu, choose Verify Replication.

Note that the verification process, by default, does not start automatically. You need to click Run Verification. If you want to stop the process, click Stop in the toolbar.