Data Transmission Service (DTS) provides the data verification feature to help you detect inconsistent data between the source and destination databases at the earliest opportunity without interrupting the services of DTS.
Background
Full data verification: compares the historical data of the object on which a DTS task runs.
Schema verification: compares the schemas of the object on which a DTS task runs.
Incremental data verification: compares the data that have undergone DML change operations on the source database in the incremental data synchronization or migration instances.
Benefits
The full data, incremental data, and schemas can be verified without interrupting the services of DTS.
The data verification feature is supported for heterogeneous databases.
Full data verification checks the row-level data of the source and destination databases. Incremental data verification checks whether the incremental data is consistent between the source and destination databases.
If inconsistent data is detected, DTS verifies the relevant data again after a specific period of time to check whether the consistency is caused by the latency of incremental data migration or synchronization.
Billing
For more information, see Billing method of data verification.
Supported regions
For more information, see Supported regions.
Supported scenarios
Data verification is supported in two-way synchronization scenarios between the following source and destination databases.
The following source and destination databases support Alibaba Cloud database instances and self-managed database instances.
Data verification mode | Source database type | Destination database type |
Full data verification | MySQL | MySQL, AnalyticDB for MySQL, PolarDB for MySQL, PolarDB-X 2.0, PostgreSQL, AnalyticDB for PostgreSQL, Oracle |
PolarDB for MySQL | MySQL, AnalyticDB for MySQL, PolarDB for MySQL, PolarDB-X 2.0, AnalyticDB for PostgreSQL, Oracle | |
PolarDB-X 2.0 | MySQL, PolarDB for MySQL, PolarDB-X 2.0, PolarDB-X 1.0 | |
PostgreSQL | MySQL, PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL, PolarDB for PostgreSQL (Compatible with Oracle), Oracle | |
PolarDB for PostgreSQL | MySQL, PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL, Oracle | |
Standalone MongoDB databases | Standalone MongoDB databases | |
MongoDB databases that use the replica set architecture | MongoDB databases that use the replica set architecture | |
MongoDB databases that use the sharded cluster architecture | MongoDB databases that use the sharded cluster architecture | |
Tair and Redis databases that use the master-replica architecture | Tair and Redis databases that use the master-replica architecture | |
Tair and Redis databases that use the cluster architecture | Tair and Redis databases that use the cluster architecture | |
SQL Server | MySQL, AnalyticDB for MySQL, PolarDB for MySQL, SQL Server, AnalyticDB for PostgreSQL | |
Oracle | AnalyticDB for MySQL, AnalyticDB for PostgreSQL, MySQL, PolarDB for MySQL, PolarDB for PostgreSQL, PolarDB for PostgreSQL (Compatible with Oracle), PostgreSQL, Oracle | |
PolarDB for PostgreSQL (Compatible with Oracle) | PolarDB for PostgreSQL (Compatible with Oracle), AnalyticDB for MySQL, Oracle | |
Db2 for LUW | MySQL, PolarDB for MySQL, AnalyticDB for MySQL, AnalyticDB for PostgreSQL | |
Db2 for i (AS/400) | MySQL | |
TiDB | MySQL, PolarDB for MySQL, AnalyticDB for MySQL | |
AnalyticDB for MySQL | MySQL, PolarDB for MySQL, AnalyticDB for MySQL | |
Incremental data verification | MySQL | MySQL, AnalyticDB for MySQL, PolarDB for MySQL, PolarDB-X 2.0, PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL |
PolarDB for MySQL | MySQL, AnalyticDB for MySQL, PolarDB for MySQL, PolarDB-X 2.0, AnalyticDB for PostgreSQL | |
PolarDB-X 2.0 | MySQL, PolarDB for MySQL, PolarDB-X 2.0 | |
PostgreSQL | MySQL, PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL | |
PolarDB for PostgreSQL | PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL | |
Standalone MongoDB databases | Standalone MongoDB databases | |
MongoDB databases that use the replica set architecture | MongoDB databases that use the replica set architecture | |
MongoDB databases that use the sharded cluster architecture | MongoDB databases that use the sharded cluster architecture | |
SQL Server | MySQL, AnalyticDB for MySQL, PolarDB for MySQL, SQL Server, AnalyticDB for PostgreSQL | |
Oracle | AnalyticDB for MySQL, MySQL, PolarDB for MySQL, PolarDB for PostgreSQL (Compatible with Oracle) | |
Schema verification | MySQL | MySQL, PolarDB for MySQL |
PolarDB for MySQL | MySQL, PolarDB for MySQL | |
PostgreSQL | PostgreSQL, PolarDB for PostgreSQL | |
PolarDB for PostgreSQL | PostgreSQL, PolarDB for PostgreSQL |
References
For more information about how to configure a data verification task, see Enable data verification.
For more information about how to view the data verification details, see View data verification details.