<style> .release-box { height: 30px; width: 100px; padding-top: 8px; text-align: center; border-radius: 5px; font-weight: bold; background-color: #d4af37; border-color: #FCE28A; } .release-box:hover { cursor: hand; cursor: pointer; opacity: .9; } </style> <meta name="robots" content="noindex"> <div class="release-box"> <a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;"> Gold </a> </div> |
ServiceNow to Database Table Compare allows you to compare records shared by bulk shares or dynamic shares with the tables in your database. With bulk shares, a list of sys_ids will be sent from ServiceNow to the DataSync Agent for the Agent to check if the records with the corresponding sys_ids exist. If there are discrepancies, a message will be sent back to ServiceNow and the missing records will be re-shared to the Agent. This process will repeat until all records have made it to the target database.
Table Compare can also compare deleted records. The Agent will check to make sure that the sys ids in the list do not exist in the database. The records that should have been deleted but was not previously deleted will be deleted immediately.
NOTE:
Listed are the supported database for table compare:
Database | Version |
---|---|
SQL Server (MSSQL) | 2017, 2019 |
MySQL | 5.X.X, 8.X.X |
Oracle | 11g - 12c (12.2.0.1.0), 19c |
PostgreSQL | 13 |
To start comparing your ServiceNow tables to your Database, follow the steps below:
|