Data Transmission Service (DTS) migrates data from a source database to a destination database. Specifically, DTS performs structure migration to migrate object structures from the source database to the destination database, performs full data migration to migrate the existing data from the source database to the destination database, and performs incremental data migration to migrate incremental data generated during the migration task to the destination database. This way, DTS migrates the source database without service downtime. In addition, DTS provides features such as migration progress display and data audit to help you ensure data integrity and determine the timing for business cutover.
Migration Types
| Migration Type | Description |
|---|---|
| Struct Migration | DTS migrates the structures of the objects to be migrated from the source database to the destination database. Tables, views, triggers, stored procedures, and other objects can be migrated. |
| Full Data Migration | DTS migrates the existing data in the tables to be migrated from the source database to the destination database. |
| Incremental Data Migration | DTS migrates incremental data generated during full data migration from the source database to the destination database. Incremental data migration helps implement data migration without service downtime. |
Supported Database Types
| Source Database Types | Destination Database Types | Migration Type |
|---|---|---|
| RDS MySQL 5.7/8.0 and self-managed MySQL 5.6/5.7/8.0 | RDS MySQL 5.7/8.0 and self-managed MySQL 5.7/8.0 | A combination of structure migration and full data migration, and a combination of structure migration, full data migration, and incremental data migration. |
| RDS PostgreSQL 12 and self-managed PostgreSQL 12 | RDS PostgreSQL 12 and self-managed PostgreSQL 12 | A combination of structure migration and full data migration, and a combination of structure migration, full data migration, and incremental data migration. |