Reconciling Data Differences in Results

After running the Verifier and identifying differences between source and target tables, you can use the Data Reconciliation feature to update the target table with differences found in the source table. For example, in the screenshot below, the source table does not contain a row with a "Product ID" value of 78. The Reconcile Data feature would modify the target table to remove the row so that source and target tables match. Syniti DR stores differences between source and target tables while running the Verifier and uses that information to modify the target table to match the source.

If the Verifier encounters errors while trying to modify the target table, the data reconciliation process stops after a default of 5 errors. You can change the limit on the number of errors encountered before stopping the process using the Verifier tab in the Options dialog. This feature is useful if, for example, a database connection fails because the option would limit the number of attempts to connect to a database.

It is possible to set which operations to reconcile (Insert, Update, Delete) using the Reconcile tab in the Verifier Options dialog.

In the Metadata Explorer, select a replication to verify.
From the right mouse button menu, choose Verify Replication.
In the Verifier Tab, click Run Verification.
Following the verficiation, the Reconcile Data icon is active.
Click Reconcile Data.
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 oprtation to compare primary keys only.
Confirm that you want to modify data in the target table.