You can use the compare table command to verify that a target table is in synchronization with its source table. You can use the compare config command to compare the data in all of the source tables in a configuration file to the data in the corresponding target tables.
The compare table and compare config command detects out-of-sync conditions in a target tables that are caused by DML operations.
- extra or missing rows
- rows whose values do not match.
Repair options fixes the out-of-sync target rows back into synchronization with the source rows.
compare table <owner.sourcetable> to <owner.targettable> target <targetservername>@o.<targetSID> repair
Compare config <config file name> repair