Data Comparison & Sync

Compare data to ensure consistency

You can compare data between Source and Target databases to see if there are any syncing differences.

Data Comparison & Sync will allow you to compare the contents by reading all records.

Select Data Compare & Sync from the Choose the project type screen.

Next, Select the source database from the pull-down menu.

You can, once again, configure your source connection. Or choose a pre-set from the Favorites menu.

Click Next to proceed to Target configuration. This is the same connection process you completed for the Full Table Copy.

Once the source and target are connected, you can run a comparison by clicking Comparison at the top right of the screen.

Progress for the Data Comparison is shown.

Data Replication

Select Replication for syncing data between source and target tables.

Omni Loader compares and applies the change script to the target. Any missing records will be inserted into the target.

When Data Replication is complete, the Run review will report what was done to correct any errors.