How to use compare command for tables in replication (17673)

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.

It detects:
- 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