DATA COMPARISON

In version 5.2.0170, Repstance introduces a data comparison feature to check and identify any data inconsistencies between Source and Target databases.

To compare data, the user needs to configure a data validation task and specify the list of tables along with the percentage of data to analyze. For each table, the user can define a list of columns for comparison, set additional conditions for data selection, and apply custom validation rules.

After the task is started, it calculates hash values of the data in the Source database and delivers them to the capture process, which then forwards them to the apply process for comparison with the hash values in the Target database. The user can monitor the status of the data comparison task and view details of any identified data discrepancies.

When the task is complete, it can be re-run to either validate all data or only the data that has changed since the last run (incremental data comparison).

Data comparison functionality is fully supported in WebUI, repcli and REST API.