Data Transmission Service (DTS) provides the data integration feature. You can configure a scheduling policy to migrate schemas and historical data from the source database to the destination database on a regular basis. This feature allows you to flexibly build data warehouses. For example, you can build a T+1 data warehouse. This topic describes the scheduling policies of data integration, the limits on scheduling policies, and the scenarios of these policies.
Supported databases
All databases that support full data migration support the data integration feature. For more information, see Overview of data migration scenarios.
Billing
Migration type | Task configuration fee | Internet traffic fee |
---|---|---|
Schema migration and full data migration | Free of charge. | Charged only when data is migrated from Alibaba Cloud over the Internet. For more information, see Billing overview. |
Configuration method
You can configure a scheduling policy for a data integration task in the Configure Migration Types and Objects step.
Note For more information about how to configure a scheduling policy, see Configure a data integration task between ApsaraDB RDS for MySQL instances.
Scheduling policies
Scheduling policy | Description | Scenario |
---|---|---|
Multi-replica mode | DTS migrates the schemas and historical data of the required objects from the source database to the destination database based on the scheduling cycle. Note
| This policy is applicable to test scenarios where test operations are performed on multiple replicas of historical data. |
Resynchronization mode | At the first scheduled time, DTS migrates the schemas and historical data of the required objects to the destination database. At each subsequent scheduled time, DTS migrates the schemas and historical data of the required objects to the destination database again. Warning
| This policy is applicable to scenarios where only the latest historical data is stored in the destination database for testing or data analysis. |
Timestamp-based incremental data mode | DTS migrates incremental data that is generated after the previous scheduling to the destination database based on the specified timestamp. This policy has the following limits:
Note
| This policy is applicable to lightweight data migration scenarios where you do not need to migrate all historical data each time. For example, you can use this policy when you build a T+1 data warehouse. |