Data validation is a feature of Data Transmission Service (DTS) that monitors data differences between source and destination databases. This feature lets you validate data between the source and destination databases without service interruption and promptly identify data and schema inconsistencies.
Background information
-
Full data validation: Compares the historical data of target objects.
-
Schema validation: Compares the database and table schemas of target objects.
-
Incremental data validation: For incremental synchronization or migration tasks, compares data for objects in the source database that have been modified by DML operations.
Advantages
-
Full data validation, incremental data validation, and schema validation can all be performed without service interruption.
-
Supports validation between heterogeneous databases.
-
Full data validation tasks validate data fields at the row level between the source and destination databases. Incremental data validation checks the consistency of incremental data between the source and destination databases.
-
If inconsistent data is found during a task, DTS re-validates the data after a period of time to confirm that the inconsistency was not caused by incremental data latency.
Pricing Information
For more information, see data validation billing methods.
Supported regions
For more information about supported regions, see list of supported regions.
Supported links
-
The two-way synchronization link between the source database and the destination database can also be verified.
-
The source and destination databases can be Alibaba Cloud database instances or self-managed database instances.
|
Data validation method |
Source database |
Destination database |
|
Full data validation |
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 |
|
|
single-node architecture MongoDB |
single-node architecture MongoDB |
|
|
ReplicaSet architecture MongoDB |
ReplicaSet architecture MongoDB |
|
|
sharded cluster architecture MongoDB |
sharded cluster architecture MongoDB |
|
|
primary/secondary replication cluster architecture Tair/Redis |
primary/secondary replication cluster architecture Tair/Redis |
|
|
Redis Cluster architecture Tair/Redis |
Redis Cluster architecture Tair/Redis |
|
|
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 validation |
MySQL |
MySQL, AnalyticDB for MySQL, PolarDB for MySQL, PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL |
|
PolarDB for MySQL |
MySQL, AnalyticDB for MySQL, PolarDB for MySQL, AnalyticDB for PostgreSQL |
|
|
PostgreSQL |
MySQL, PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL |
|
|
PolarDB for PostgreSQL |
PostgreSQL, AnalyticDB for PostgreSQL, PolarDB for PostgreSQL |
|
|
single-node architecture MongoDB |
single-node architecture MongoDB |
|
|
ReplicaSet architecture MongoDB |
ReplicaSet architecture MongoDB |
|
|
sharded cluster architecture MongoDB |
sharded cluster architecture MongoDB |
|
|
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 validation |
MySQL |
MySQL, PolarDB for MySQL |
|
PolarDB for MySQL |
MySQL, PolarDB for MySQL |
|
|
PostgreSQL |
PostgreSQL, PolarDB for PostgreSQL |
|
|
PolarDB for PostgreSQL |
PostgreSQL, PolarDB for PostgreSQL |
Operation documents
-
To configure a data validation task, see Configure data validation.
-
To view data validation details, see View data validation details.