Table Compare (found under DataSync > Tools) allows you to compare a table on your ServiceNow instance with the table in another database or another ServiceNow instance. By comparing two tables, you can see each table's record count as well as a list of record discrepancies by sys_id between the two tables that you are comparing (i.e. which records exist in one table and not in the other).
NOTE: Most recent update of the record is checked for. If the most recent record is not found, the record will be re-shared.
The table compare messages have a 300 second delay by default. Configuring this property is suggested for cases where the compare messages come before all shared messages are received, causing discrepancies. To modify the delay length, go to u_psp_properties.list in the filter navigator, search com.perspectium.table_compare.message_delay in the Name field.
Legacy Table Compare: ServiceNow to ServiceNow
Learn how to run a table compare for two ServiceNow instances via DataSync for ServiceNow.
ServiceNow to Database Table Compare
Learn how to run a table compare for a ServiceNow instance and a database via DataSync for ServiceNow.