A workspace for data warehouse development consists of two parts: data warehouse solutions and business scenarios. Data warehouse solutions allow you to create and run real-time synchronization and migration tasks to migrate or integrate full data and incremental data in a quasi-real-time manner. This way, data migration and integration needs in business scenarios can be met.
- Real-time synchronization: transmits data by using the data synchronization feature of Data Transmission Service (DTS). For more information about how to create a real-time synchronization task, see the Create a real-time synchronization task section of this topic.
- Real-time migration: transmits data by using the data migration feature of DTS. For more information about how to create a real-time migration task, see the Create a real-time migration task section of this topic.
- For DTS-based data synchronization and migration tasks, you can check the task status by using the DTS checkpoint nodes.
- For more information about the differences between data synchronization and migration, see the What are the differences between data migration and data synchronization? section in this topic.
Create a real-time synchronization task
Create a real-time migration task
What are the differences between data migration and data synchronization?
Item | Data migration | Data synchronization |
---|---|---|
Scenarios | The data migration feature is used to migrate data from on-premises databases, user-created
databases hosted on ECS, and databases on third-party cloud platforms to Alibaba Cloud.
You can release a data migration task immediately after it is complete. |
The data synchronization feature is used to synchronize data between two data sources
in real time. It is suitable for scenarios such as active geo-redundancy, disaster
recovery, cross-border data synchronization, query load balancing, cloud BI systems,
and real-time data warehousing.
After you create a data synchronization task, it continuously synchronizes data between the specified data sources to ensure data consistency. |
Supported databases | For more information, see Supported databases. | For more information, see Supported databases. |
Supported deployment locations of databases |
|
Note The data synchronization feature ensures low network latency through data transmission
over the internal network.
|
Features | You can read and migrate data across user-created databases that are deployed on VPCs owned by different Alibaba cloud accounts. |
|
Billing methods | Only the pay-as-you-go billing method is supported. | The pay-as-you-go and subscription billing methods are supported. |
Billing rules | You are billed when incremental data migration is in progress, including the period when incremental data migration is paused. You are not billed for schema migration and full data migration. |
|