Data Transmission Service (DTS) handles data migration, real-time synchronization, and change tracking across relational database management systems (RDBMS), NoSQL, and online analytical processing (OLAP) databases. An intuitive console lets you create and manage instances without writing custom scripts.
Capabilities at a glance
| Capability | Description |
|---|---|
| Data migration | Migrate data between homogeneous or heterogeneous sources with minimized downtime |
| Real-time data synchronization | Sync data one-way or two-way between two sources in real time |
| Change tracking | Capture and stream incremental data changes to downstream consumers |
| Data verification | Validate data accuracy between source and destination automatically |
| Schema conversion | Convert schemas during heterogeneous migration, such as Oracle synonyms to PolarDB for PostgreSQL (Compatible with Oracle) clusters |
High performance
DTS uses high-specification servers with an optimized data transfer infrastructure:
Full data migration peak rate: 70 MB per second or 200,000 transactions per second (TPS)
Data synchronization peak rate: 30,000 records per second (RPS), achieved through concurrent transaction processing across a single table
Compressed data transmission reduces bandwidth utilization during transfer
The performance indicators are for reference only. Actual performance depends on source and destination database performance, network latency, network bandwidth, and instance specifications.
High reliability
DTS is built on a cluster architecture with multiple layers of protection:
Automatic failover: If a node fails, the control center migrates all tasks to a healthy node within seconds.
Continuous data validation: A 24 x 7 validation mechanism detects and corrects inaccurate data to maintain integrity.
Resumable transmission: DTS monitors task states and automatically restarts tasks after network failures or system exceptions. If an error persists, resolve it manually in the DTS console.
Secure authentication: Secure transmission protocols and tokens authenticate all communication between DTS modules.
Network isolation: For cross-border or cross-region synchronization instances, use a dedicated Express Connect Circuit to isolate network traffic.
Encrypted connections: SSL encryption is supported for connections to compatible databases.
Ease of use
The DTS console provides a guided interface for creating instances. Once a task is running, the console shows real-time status, progress, and performance metrics so you can monitor and manage tasks without additional tooling.
Use cases
Real-time data synchronization supports both one-way and two-way synchronization, making it suitable for:
Geo-disaster recovery — replicate data to a standby region for business continuity
Active geo-redundancy — keep multiple active regions in sync
Nearby application access — route users to the closest data source
Query load balancing — distribute read traffic across nodes
Real-time data warehousing — stream operational data into an analytics system
Data migration with minimized downtime
During data migration, source databases remain operational. Application downtime is reduced to minutes.
DTS supports migration between homogeneous sources (for example, MySQL to MySQL) and heterogeneous sources (for example, Oracle to PolarDB for PostgreSQL (Compatible with Oracle) clusters), including automatic schema conversion for heterogeneous migrations.