Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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). 

(info) NOTEMost recent update of the record is checked for. If the most recent record is not found, the record will be res-haredre-shared.

To delay the table compare messages, set a desired value to the property com.perspectium.table_compare.message_delay in seconds (default is 300 seconds). Configuring this property is suggested for cases where the compare messages comes before all the other shared messages, causing discrepancies. To configure the property, go to u_psp_properties.list in the filter navigator, then search com.perspectium.table_compare.message_delay in the Name field.


ServiceNow to ServiceNow Table Compare


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.