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
- Log on to the DMS console V5.0.
- In the top navigation bar, click DTS. In the left-side navigation pane, choose .
- Click the name of the workspace in which you want to create a real-time synchronization task.
- In the left-side navigation pane of the workspace, click the
icon and choose .
Note You can also right-click Data Warehouse Solutions in the left-side navigation pane of the workspace and choose . - Create and purchase a real-time synchronization task.
DTS supports the following data synchronization scenarios. You can select one of the following scenarios based on your business requirements to view the supported database versions, synchronization types, and configuration procedure.
- Synchronize data from a self-managed MySQL database or an ApsaraDB RDS for MySQL instance
- Synchronize data from a PolarDB for MySQL cluster
- Synchronize data from a PolarDB-X instance
- Synchronize data from a PolarDB for Oracle cluster
- Synchronize data from an Oracle database
- Synchronize data from a self-managed PostgreSQL database or an ApsaraDB RDS for PostgreSQL instance
- Synchronize data from a self-managed SQL Server database or an ApsaraDB RDS for SQL Server instance
- Synchronize data from a self-managed MongoDB database or an ApsaraDB for MongoDB instance
- Synchronize data from a self-managed Redis database, a Tair instance, or an ApsaraDB for Redis instance
- Synchronize data from a Db2 for LUW database
- Synchronize data from a Db2 for i database
- Synchronize data from a Data Management (DMS) logical database
Create a real-time migration task
- Log on to the DMS console V5.0.
- In the top navigation bar, click DTS. In the left-side navigation pane, choose .
- Click the name of the workspace in which you want to create a real-time migration task.
- In the left-side navigation pane of the workspace, click the
icon and choose .
Note You can also right-click Data Warehouse Solutions in the left-side navigation pane of the workspace and choose . - Create and purchase a real-time migration task.
DTS supports the following data migration solutions. Select the corresponding data migration solution based on your actual scenario to view the supported database versions, migration types, and configuration procedure.
- Migrate data from a self-managed MySQL database or an ApsaraDB RDS for MySQL instance
- Migrate data from a PolarDB for MySQL cluster
- Migrate data from a PolarDB for Oracle cluster
- Migrate data from a PolarDB-X instance
- Migrate data from an Oracle database
- Migrate data from a self-managed PostgreSQL database or an ApsaraDB RDS for PostgreSQL instance
- Migrate data from a self-managed SQL Server database or an ApsaraDB RDS for SQL Server instance
- Migrate data from a self-managed MongoDB database or an ApsaraDB for MongoDB instance
- Migrate data from a self-managed Redis database, a Tair instance, or an ApsaraDB for Redis instance
- Migrate data from a self-managed Db2 for LUW database
- Migrate data from a self-managed Db2 for i database
- Migrate data from a Teradata database
- Migrate data from a self-managed HBase database
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, self-managed databases hosted on Elastic Compute Service (ECS), and databases on third-party cloud vendors 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 database services | For more information, see Overview of data migration scenarios. | For more information, see Overview of data synchronization scenarios. |
Supported deployment environments of databases |
|
Note The data synchronization feature ensures low network latency through data transmission over an internal network. |
Features |
|
|
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 only 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. |
|