Before you configure a data synchronization instance in Data Transmission Service (DTS), review the precautions and limits for your synchronization path. Each source-to-destination combination has specific requirements that affect schema synchronization, initial full data synchronization, and incremental data synchronization.
The following table lists all supported synchronization paths. Click a link to view the precautions and limits for that path.
Synchronization paths from a MySQL database
| Destination | Precautions and limits |
|---|---|
| MySQL | Synchronize data between MySQL databases |
| PolarDB for MySQL cluster | Synchronize data from a MySQL database to a PolarDB for MySQL cluster |
| AnalyticDB for MySQL cluster | Synchronize data from a MySQL database to an AnalyticDB for MySQL cluster |
| AnalyticDB for PostgreSQL instance | Synchronize data from a MySQL database to an AnalyticDB for PostgreSQL instance |
| DataHub project | Synchronize data from a MySQL database to a DataHub project |
| Elasticsearch cluster | Synchronize data from a MySQL database to an Elasticsearch cluster |
| MaxCompute project | Synchronize data from a MySQL database to a MaxCompute project |
| Tablestore instance | Synchronize data from a MySQL database to a Tablestore instance |
| Message Queue for Apache Kafka instance or self-managed Kafka cluster | Synchronize data from a MySQL database to a Message Queue for Apache Kafka instance or a self-managed Kafka cluster |
| PolarDB-X instance | Synchronize data from a MySQL database to a PolarDB-X instance |
Synchronization paths from a PolarDB for MySQL cluster
Synchronization paths from a self-managed Oracle database
| Destination | Precautions and limits |
|---|---|
| AnalyticDB for PostgreSQL instance | Synchronize data from a self-managed Oracle database to an AnalyticDB for PostgreSQL instance |
| DataHub project | Synchronize data from a self-managed Oracle database to a DataHub project |
Synchronization paths from a PostgreSQL database
| Destination | Precautions and limits |
|---|---|
| AnalyticDB for PostgreSQL instance | Synchronize data from a self-managed PostgreSQL database or an ApsaraDB RDS for PostgreSQL instance to an AnalyticDB for PostgreSQL instance |
Synchronization paths from an SQL Server database
| Destination | Precautions and limits |
|---|---|
| SQL Server | Synchronize data between SQL Server databases |
| MySQL | Synchronize data from an ApsaraDB RDS for SQL Server instance to a MySQL database |
| AnalyticDB for MySQL cluster | Synchronize data from an SQL Server database to an AnalyticDB for MySQL cluster |
| AnalyticDB for PostgreSQL instance | Synchronize data from an SQL Server database to an AnalyticDB for PostgreSQL instance |