Document Center

    Data Transmission Service (DTS)

    • Product Updates
      • Release notes
    • Notices
      • [Announcement] Data written to AnalyticDB for MySQL clusters is no longer garbled as of July 15, 2021
      • [Notice] DTS upgrades cluster resources as of June 11, 2021
      • [Notice] Data query feature in change tracking of the new and previous versions discontinued during March 4, 2021 and July 29, 2021
      • [Notice] ApsaraDB RDS for MySQL users can no longer use the previous change tracking feature after March 31, 2020
    • Introduction
      • What is Data Transmission Service?
      • Supported sources and targets
      • How it works
      • Benefits
      • Use cases
      • Limits
      • Glossary
      • FAQ
    • Billing
      • Billing methods
      • Expiration policies for subscriptions
      • Overdue payments for pay-as-you-go
      • Renew a subscription instance
      • Switch from pay-as-you-go to subscription
    • Quick Start
      • Create a data integration task
      • Create a data migration task
      • Create a data synchronization task
      • Create a change tracking task
    • Network Setup
      • Set up a network environment for replication
      • Whitelist DTS IP ranges for your user-created database
      • Connect your on-premises networks to Alibaba Cloud
      • Connect a non-Alibaba Cloud database to Alibaba Cloud Database Gateway
      • Connect your on-premises networks to Alibaba Cloud over an IPsec-VPN tunnel
    • Replication Modes
      • Data migration mode
      • Data integration mode
      • Data synchronization mode
      • Change tracking mode
    • Performance
      • Data migration performance data
      • Data synchronization performance data
    • Instance Management
      • Upgrade instance specification
      • Upgrade synchronization topology from one-way to two-way
      • Change the password of a database account
      • Query the operations logs of instances
      • View task logs
      • Release pay-as-you-go instances
      • Set alert rules for DTS tasks in the Cloud Monitor console
      • Tag management
        • Create or bind tags
        • Filter DTS instances by tag
        • View the tags bound to a DTS instance
        • Unbind or delete tags
    • Manage ETL tasks
      • Create an ETL task
        • Configure an ETL task
        • Configure a source database
        • Configure the transformation components
        • Configure the destination database
        • Create a connection template
    • Data Synchronization
      • Overview of data synchronization scenarios
      • Synchronization topologies
      • Data type mappings for schema synchronization
      • Precautions and limits
        • Precautions and limits for synchronizing data from a MySQL database
        • Precautions and limits for synchronizing data from a PolarDB for MySQL cluster
        • Precautions and limits for synchronizing data from a PostgreSQL database
        • Precautions and limits for synchronizing data from an SQL Server database
      • Prepare the database accounts for data synchronization
      • Synchronization task management
        • Rename an object to be synchronized
        • Use SQL conditions to filter data
        • Specify the capitalization of object names in the destination instance
        • Modify the naming rules for additional columns
        • View the connection status and performance of data synchronization
        • Reset a data synchronization task
        • Add an object to a data synchronization task
        • Remove an object from a data synchronization task
        • Stop a data synchronization task
        • Troubleshoot precheck failures
        • Data formats of a Kafka cluster
        • Specify the policy for synchronizing data to Kafka partitions
      • Synchronize data between MySQL databases
        • Configure two-way data synchronization between ApsaraDB RDS for MySQL instances
        • Configure one-way data synchronization between ApsaraDB RDS for MySQL instances
        • Synchronize data from a self-managed MySQL database hosted on ECS to an ApsaraDB RDS for MySQL instance
        • Synchronize data from a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an ApsaraDB RDS for MySQL instance
        • Synchronize data between ApsaraDB RDS for MySQL instances that belong to different Alibaba Cloud accounts
        • Synchronize data from an ApsaraDB RDS for MySQL instance to a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway
      • Synchronize data from a MySQL database to a different type of database
        • Synchronize data from an ApsaraDB RDS for MySQL instance to a PolarDB for MySQL cluster
        • Synchronize data from a self-managed MySQL database hosted on ECS to a PolarDB for MySQL cluster
        • Synchronize data from a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to a PolarDB for MySQL cluster
        • Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for MySQL cluster
        • Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a self-managed MySQL database hosted on ECS to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a self-managed MySQL database hosted on ECS to an Elasticsearch cluster
        • Synchronize data from an ApsaraDB RDS for MySQL instance to a MaxCompute project
        • Synchronize data from a self-managed MySQL database to a Message Queue for Apache Kafka instance
        • Synchronize data from an ApsaraDB RDS for MySQL instance to a self-managed Kafka cluster
        • Synchronize data from a self-managed MySQL database hosted on ECS to a self-managed Kafka cluster
        • Synchronize data from a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to a self-managed Kafka cluster
      • Synchronize data to or from an Apsara PolarDB for MySQL cluster
        • Configure two-way data synchronization between PolarDB for MySQL clusters
        • Configure one-way data synchronization between PolarDB for MySQL clusters
        • Synchronize data from a PolarDB for MySQL cluster to an ApsaraDB RDS for MySQL instance
        • Synchronize data from a PolarDB for MySQL cluster to an Elasticsearch cluster
        • Synchronize data from a PolarDB for MySQL cluster to a self-managed Kafka cluster
        • Synchronize data from a PolarDB for MySQL cluster to an AnalyticDB for MySQL cluster
        • Synchronize data from a PolarDB for MySQL cluster to an AnalyticDB for PostgreSQL instance
      • Synchronize data to or from a PolarDB-O cluster
        • Configure one-way data synchronization between PolarDB-O clusters
        • Synchronize data from a PolarDB-O cluster to a self-managed Kafka cluster
      • Synchronize data to or from a PolarDB-X instance
        • Synchronize data between DRDS instances
        • Synchronize data from a DRDS instance to an AnalyticDB for MySQL cluster
        • Synchronize data from a DRDS instance to an AnalyticDB for PostgreSQL instance
      • Synchronize data between Redis databases
        • Configure one-way data synchronization between ApsaraDB for Redis instances
        • Synchronize data between ApsaraDB for Redis cluster instances across Alibaba Cloud accounts
        • Configure two-way data synchronization between ApsaraDB for Redis Enhanced Edition (Tair) instances
        • Use OpenAPI Explorer to configure one-way or two-way data synchronization between ApsaraDB for Redis Enhanced Edition (Tair) instances
        • Synchronize data from a self-managed Redis database hosted on ECS to an ApsaraDB for Redis instance
        • Synchronize data from a self-managed Redis database connected over Express Connect, VPN Gateway, or Smart Access Gateway to a self-managed Redis database hosted on ECS
        • Synchronize data from a self-managed Redis cluster to an ApsaraDB for Redis cluster instance
        • Synchronize data from a Codis cluster hosted on ECS to an ApsaraDB for Redis instance
        • Synchronize data from a Twemproxy Redis cluster hosted on ECS to an ApsaraDB for Redis instance
      • Synchronize data from an ApsaraDB RDS for SQL Server instance
        • Synchronize data from an ApsaraDB RDS for SQL Server instance to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a self-managed SQL Server database hosted on ECS to an AnalyticDB for PostgreSQL instance
      • Synchronize data between PostgreSQL databases
        • Synchronize data from an ApsaraDB RDS for PostgreSQL instance to an AnalyticDB for PostgreSQL instance
        • Synchronize data from a self-managed PostgreSQL database to an AnalyticDB for PostgreSQL instance
      • Synchronize data from a TiDB database
        • Synchronize data from a self-managed TiDB database to an AnalyticDB for MySQL cluster
    • Data Migration
      • Overview of data migration scenarios
      • Data type mappings between heterogeneous databases
      • Precautions and limits
        • Precautions and limits for migrating data from a MySQL database
        • Precautions and limits for migrating data from a PolarDB for MySQL cluster
        • Precautions and limits for migrating data from a PolarDB-O cluster
        • Precautions and limits for migrating data from an Oracle database
        • Precautions and limits for migrating data from a PostgreSQL database
        • Precautions and limits for migrating data from an SQL Server database
      • Prepare the database accounts for data migration
      • Migration task management
        • Object name mapping
        • Specify the capitalization of object names in the destination instance
        • Filter the data to be migrated
        • View the progress of a data migration task
        • View the connection status and performance of full data migration
        • View the connection status and performance of incremental data migration
        • Modify the transfer rate of full data migration
        • Fix a failed data migration task
        • Switch workloads to the destination database
        • Stop a data migration task
        • Data formats of a Kafka cluster
        • Specify the policy for migrating data to Kafka partitions
      • Precheck and troubleshooting
        • Checks the connectivity of the source database during DTS PreCheck
        • The Binlog PreCheck items fail during incremental data migration by using DTS
        • How to perform constrained integrity check during the PreCheck process
        • Failed to check the MySQL storage engine during DTS incremental data migration
        • SOURCE database account permissions
        • Destination Database permissions
        • Failed to check the existence prompt of objects with the same name in the PreCheck phase
        • A schema existence check error occurs when DTS tasks run in PreCheck
        • Failed to check the server_id of the DTS source database
        • The destination database failed to pass the connectivity check during DTS Data Migration
        • Source database version
      • Migrate data from a self-managed database to Alibaba Cloud
        • Source database: MySQL
          • Migrate data from a self-managed MySQL database to an ApsaraDB RDS for MySQL instance
          • Migrate data from a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an ApsaraDB RDS for MySQL instance
          • Migrate data from a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an ApsaraDB RDS for MySQL instance across Alibaba Cloud accounts
          • Migrate data from a self-managed MySQL database to a PolarDB for MySQL cluster
          • Migrate data from a self-managed MySQL database to a DRDS instance
        • Source database: SQL Server
          • Migrate incremental data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance
          • Migrate full data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance
        • Source database: Oracle
          • Migrate data from a self-managed Oracle database to a PolarDB-O cluster
          • Migrate data from a self-managed Oracle database to an ApsaraDB RDS for MySQL instance
          • Migrate data from a self-managed Oracle database to a PolarDB for MySQL cluster
          • Migrate data from a self-managed Oracle database to a DRDS instance
          • Migrate data from a self-managed Oracle database to an ApsaraDB RDS for PPAS instance
          • Migrate data from a self-managed Oracle database to an AnalyticDB for PostgreSQL instance
          • Migrate data from a self-managed Oracle database to a Message Queue for Apache Kafka instance
        • Source database: PostgreSQL
          • Migrate incremental data from a self-managed PostgreSQL database (version 10.1 to 13) to an ApsaraDB RDS for PostgreSQL instance
          • Migrate incremental data from a self-managed PostgreSQL database (versions 9.4.8 to 10.0) to an ApsaraDB RDS for PostgreSQL instance
          • Migrate full data from a self-managed PostgreSQL database to an ApsaraDB RDS for PostgreSQL instance
        • Source database: Redis
          • Migrate data from a self-managed Redis database to an ApsaraDB for Redis instance
        • Source database: MongoDB
          • Migrate a self-managed standalone MongoDB database to Alibaba Cloud by using DTS
          • Migrate the replica set of a self-managed MongoDB database to Alibaba Cloud by using DTS
          • Migrate the shards of a self-managed MongoDB database to Alibaba Cloud by using DTS
        • Source database: TiDB
          • Migrate incremental data from a self-managed TiDB database to an ApsaraDB RDS for MySQL instance
          • Migrate full data from a self-managed TiDB database to an ApsaraDB RDS for MySQL instance
        • Source database: Db2
          • Migrate data from a self-managed Db2 database to an ApsaraDB RDS for MySQL instance
      • Migrate data from a third-party cloud to Alibaba Cloud
        • Migrate data from an Amazon RDS for MySQL instance to an ApsaraDB RDS for MySQL instance
        • Migrate data from an Amazon RDS for Oracle instance to an ApsaraDB RDS for MySQL instance
        • Migrate full data from an Amazon RDS for Oracle instance to an ApsaraDB RDS for PPAS instance
        • Migrate incremental data from an Amazon RDS for PostgreSQL instance to an ApsaraDB RDS for PostgreSQL instance
        • Migrate full data from an Amazon RDS for PostgreSQL instance to an ApsaraDB RDS for PostgreSQL instance
        • Migrate full data from an Amazon RDS for SQL Server instance to an ApsaraDB RDS for SQL Server instance
        • Migrate data from an Amazon Aurora MySQL cluster to an ApsaraDB RDS for MySQL instance
        • Migrate data from an Amazon Aurora MySQL cluster to a PolarDB for MySQL cluster
        • Migrate full data from an Amazon Aurora PostgreSQL instance to an ApsaraDB RDS for PostgreSQL instance
        • Migrate data from a MongoDB Atlas database to Alibaba Cloud
      • Migrate data between instances of the same Alibaba Cloud account
        • Migrate data between RDS instances
        • Migrate data from an ApsaraDB RDS for MariaDB TX instance to an ApsaraDB RDS for MySQL instance
        • Migrate data from an ApsaraDB RDS for MySQL instance to a PolarDB for MySQL cluster
        • Migrate data from an ApsaraDB RDS for PPAS instance to a PolarDB-O cluster
        • Migrate data between PolarDB for MySQL clusters
        • Migrate data from a PolarDB for MySQL cluster to an ApsaraDB RDS for MySQL instance
        • Migrate data between PolarDB-O clusters
        • Migrate data from a standalone instance to a replica set instance or sharded cluster instance
        • Migrate data from a replica set MongoDB instance to a sharded cluster instance
        • Migrate data between ApsaraDB for MongoDB instances across regions
        • Migrate data from a MaxCompute project to an ApsaraDB RDS for MySQL instance
      • Migrate data between instances of different Alibaba Cloud accounts
        • Migrate data between ApsaraDB for MongoDB instances of different Alibaba Cloud accounts
        • Migrate data between RDS instances of different Alibaba Cloud accounts
        • Migrate data between PolarDB for MySQL clusters of different Alibaba Cloud accounts
      • Migrate data from Alibaba Cloud to a self-managed database
        • Migrate data from an ApsaraDB RDS for MySQL instance to a self-managed MySQL database
        • Migrate data from an ApsaraDB RDS for MySQL instance to a self-managed Kafka cluster
        • Migrate data from a PolarDB for MySQL cluster to a self-managed MySQL database
        • Migrate data from a PolarDB for PostgreSQL cluster to a self-managed Oracle database
      • Migrate data between self-managed databases
        • Migrate data between self-managed Oracle databases
    • Change Tracking
      • Overview of change tracking scenarios
      • Prepare the source database account for change tracking
      • Change Tracking Configuration and Management
        • Track data changes from an ApsaraDB RDS for MySQL instance
        • Track data changes from a PolarDB for MySQL cluster
        • Track data changes from a self-managed Oracle database
        • Modify the objects for change tracking
        • View tracked data changes
        • Reset a change tracking task
      • Tracked Data Consumption
        • Create consumer groups
        • Manage consumer groups
        • Use the SDK demo code to consume tracked data
        • Use flink-dts-connector to consume tracked data
        • Use a Kafka client to consume tracked data
      • Change tracking (previous)
        • Track data changes from an ApsaraDB RDS for MySQL instance
        • Track data changes from a DRDS instance
        • Modify the consumption checkpoint
        • Modify objects for change tracking
        • View tracked data changes
        • Methods of the SDK demo code
        • Run the SDK demo code
        • Parse tracked SQL statements
        • Use the SDK demo code to consume tracked data
        • Download a change tracking SDK
    • Data Integration
      • Configure a data integration task between ApsaraDB RDS for MySQL instances
      • Scheduling policies of data integration
      • Manage a data integration task
      • Modify the settings of a scheduling policy
      • View historical tasks
    • RAM-based Access Control
      • Authorize DTS to access Alibaba Cloud resources
      • Use a system policy to authorize a RAM user to manage DTS instances
      • Use a custom policy to authorize a RAM user to manage DTS instances
      • Authorize a RAM user to use the DTS SDK
      • Configure RAM authorization for cross-account data migration and synchronization
      • Configure RAM authorization for data migration or synchronization from a user-created database in a VPC across different Alibaba Cloud accounts
    • Best Practices
      • Switch workloads to the destination database
      • Use triggers and functions to implement incremental DDL migration for PostgreSQL databases
      • Disable slow query log to improve migration performance
      • Change the character set of an ApsaraDB RDS for MySQL instance
      • Configure a data synchronization task for a source database that contains a trigger
      • Migrate data between databases that have different names
      • Disaster tolerance of data subscription SDK
      • Set a cache update policy by using the change tracking feature
    • API Reference
      • RAM authorization
      • Common parameters
      • Request syntax
      • List of supported regions
      • DTS API (new)
        • List of operations by function
        • CreateDtsInstance
        • ConfigureDtsJob
        • ConfigureSubscription
        • StartDtsJob
        • Manage consumer groups for subscription tasks
          • CreateConsumerChannel
          • DescribeConsumerChannel
          • ModifyConsumerChannel
          • DeleteConsumerChannel
        • SkipPreCheck
        • Describe DTS Job
          • DescribeDtsJobDetail
          • DescribeDtsJobs
          • DescribePreCheckStatus
          • WhiteIpList
        • Modify DTS Job
          • ModifyDtsJob
          • ModifySubscription
          • ModifyDtsJobPassword
          • ModifyDtsJobName
          • UpgradeTwoWay
          • TransferPayType
          • TransferInstanceClass
          • RenewInstance
        • ResetDtsJob
        • SuspendDtsJob
        • StopDtsJob
        • DeleteDtsJob
        • DTS Job Monitor Rule
          • CreateJobMonitorRule
          • DescribeJobMonitorRule
        • Tag management
          • TagResources
          • ListTagResources
          • UntagResources
        • More description of parameters
          • Objects of DTS tasks
      • DTS API
        • List of operations by function
        • Data migration
          • CreateMigrationJob
          • ConfigureMigrationJob
          • ConfigureMigrationJob
          • StartMigrationJob
          • SuspendMigrationJob
          • DescribeMigrationJobs
          • DescribeMigrationJobDetail
          • DescribeMigrationJobStatus
          • StopMigrationJob
          • DeleteMigrationJob
        • Data synchronization
          • CreateSynchronizationJob
          • ConfigureSynchronizationJob
          • StartSynchronizationJob
          • SuspendSynchronizationJob
          • ResetSynchronizationJob
          • ModifySynchronizationObject
          • DescribeSynchronizationObjectModifyStatus
          • SwitchSynchronizationEndpoint
          • DescribeEndpointSwitchStatus
          • ConfigureSynchronizationJobReplicatorCompare
          • DescribeSynchronizationJobReplicatorCompare
          • DescribeSynchronizationJobs
          • DescribeInitializationStatus
          • DescribeSynchronizationJobStatusList
          • DescribeSynchronizationJobStatus
          • DeleteSynchronizationJob
        • Change tracking
          • CreateSubscriptionInstance
          • ConfigureSubscriptionInstance
          • StartSubscriptionInstance
          • ModifySubscriptionObject
          • Manage consumer groups
            • CreateConsumerGroup
            • DescribeConsumerGroup
            • ModifyConsumerGroupPassword
            • DeleteConsumerGroup
            • ModifyConsumptionTimestamp
          • DescribeSubscriptionInstances
          • DescribeSubscriptionInstanceStatus
          • DeleteSubscriptionInstance
        • Network setup
          • DescribeDTSIP
          • DescribeConnectionStatus
        • Monitoring and alerting
          • ConfigureMigrationJobAlert
          • DescribeMigrationJobAlert
          • ConfigureSubscriptionInstanceAlert
          • DescribeSubscriptionInstanceAlert
          • ConfigureSynchronizationJobAlert
          • DescribeSynchronizationJobAlert
        • Task management
          • ShieldPrecheck
        • Supplementary description of parameters
          • MigrationObject
          • SubscriptionObjects
          • SynchronizationObjects
          • MigrationReserved
    • SDK Reference
      • Use DTS SDK for Java
      • Download SDKs
    • Troubleshooting
    • Troubleshooting
      • Common error codes and troubleshooting methods
      • What can I do if full data migration stops or slows down?
      • How do I troubleshoot the incremental migration latency or synchronization latency of DTS?
      • What can I do if DTS fails to obtain the schemas of the source database when I configure a task?
      • What do I do if a connection failure occurs when I configure a task?
      • What can I do if data loss occurs in the destination database due to inconsistent case sensitivity of character sets in the source and destination databases?
      • What can I do if data loss occurs in the destination database due to online DDL operations performed in a table merging task?
      • What can I do if data loss occurs after I perform two-way synchronization among three instances?
      • Precheck failed
        • What can I do if the message "The source database account does not have the sysadmin permission" appears?
        • What can I do if a task fails to pass the precheck "Multiple Usernames for One Instance"?
        • What can I do if the DTS instance cannot connect to the source or destination database?
 
All Products
Search

This Product

  • This Product
  • All Products

    Overview of data synchronization scenarios

    Document Center

    Overview of data synchronization scenarios

    Last Updated: Sep 04, 2021

    For information about the database types, synchronization types, and synchronization topologies that are supported by the data synchronization feature, see Database types, initial synchronization types, and synchronization topologies. The topic also provides links to the relevant references.

    Next: Release notes

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.
      Free Trial Free Trial