Overview

Data validation is a feature provided by OceanBase Migration Service (OMS) to compare the data differences between the source and target databases. This feature allows you to compare the data differences between the source and target databases without interrupting services, helping you promptly identify data inconsistencies.

Validation types

OMS supports three validation types: full validation, row count validation, and incremental validation, which can meet most data validation requirements.

• Full validation: Full validation involves comparing the full data of the source and target databases to verify the data. The validation results are accurate but the process is time-consuming. Full validation is suitable for one-time validation on static data.

• Row count validation: Row count validation involves comparing the number of rows in the source and target databases to verify the data. The validation process is fast, but it cannot verify the actual data text. Row count validation is suitable for scenarios with a large amount of data where data consistency is not highly sensitive.

• Incremental validation: Incremental validation involves comparing the incremental change data of the source and target databases to verify the data. The validation results are accurate, but the resource consumption is high. Incremental validation is suitable for supplementary validation of subsequent change data after full validation during the migration switchover.

Validation task support