DTS supports data migration and synchronization between various types of data sources. The following parts describe the supported databases in each scenario.
Data Migration
| Source Database Type and Version | Destination Database Type and Version | Migration Type | Remarks |
|---|---|---|---|
| TeleDB for MySQL or self-managed MySQL 5.6/5.7/8.0 | TELEDB FOR MYSQL | Struct migration, full data migration, incremental data migration, and entire database migration | (1) The major version of the destination database cannot be earlier than that of the source database. (2) Partitioned tables are supported. |
| TeleDB for PostgreSQL or self-managed PostgreSQL 12.x | TELEDB FOR POSTGRESQL | Struct migration, full data migration, incremental data migration, and entire database migration | (1) The major version of the destination database cannot be earlier than that of the source database. (2) Partitioned tables are supported. (3) Tables with incremental data synchronization enabled must have a primary key. (4) Entire database synchronization does not support the mapping of database or table names. |
Data Synchronization
| Source Database Type and Version | Destination Database Type and Version | Synchronization Type | Remarks |
|---|---|---|---|
| TeleDB for MySQL or self-managed MySQL 5.6/5.7/8.0 | TELEDB FOR MYSQL | Struct synchronization, full data synchronization, incremental data synchronization, and entire database synchronization | (1) The major version of the destination database cannot be earlier than that of the source database. (2) DTS supports synchronization based on offsets if full data synchronization is not selected. (3) Partitioned tables are supported. (4) Tables with incremental data synchronization enabled must have a primary key. (5) Entire database synchronization does not support the mapping of database or table names. |
| TeleDB for PostgreSQL or self-managed PostgreSQL 12.x | TELEDB FOR POSTGRESQL | Struct synchronization, full data synchronization, incremental data synchronization, and entire database synchronization | (1) The major version of the destination database cannot be earlier than that of the source database. (2) Partitioned tables are supported. (3) Tables with incremental data synchronization enabled must have a primary key. (4) Entire database synchronization does not support the mapping of database or table names. |