DTS supports data transmission between database engines, such as RDBMS, NoSQL, and OLAP, and provides data migration, data subscription, and data synchronization for different scenarios. The following features are available for creating and managing DTS instances.
Data migration enables you to migrate data between databases with zero downtime. All data changes that occur to the source database during migration are replicated to the target database. After the data migration is completed, the target database remains synchronous with the source database for a period of time. This allows you to switch over the databases at your convenience.
DTS supports data migration and synchronization between homogeneous and heterogeneous data sources. For example, you can use DTS to migrate data from Oracle to MySQL and from Oracle to Postgres Plus Advanced Server. For migration between heterogeneous data sources, DTS supports the conversion of structural object definition. For example, the schema in Oracle is converted according to the structural definition in Postgres Plus Advanced Server.
Zero downtime data migration minimizes the impact of data migration on applications, streamlining your data migration to cloud.
DTS adopts a highly-configured server to ensure excellent performance of each migration or synchronization link.
For data migration, DTS performs a variety of transmission optimization measures on the service base. The transmission speed of existing data migration at its peak can reach 70 MB per second, or 200,000 records per second.
Compared with traditional data synchronization tools, the real-time synchronization function of DTS refines the concurrency granularity to the transaction level. It also supports multiple network optimization methods, such as compressed transmission and packet retransmission, greatly improving the synchronization performance. At its peak performance, the synchronization speed can reach 30,000 records per second.
DTS guarantees a 99.95% link reliability due to the following features:
DTS is built on service clusters. Any node down or fault in the cluster triggers DTS to immediately switch all tasks on that node to other nodes within the cluster.
DTS provides 24*7 data accuracy validation for some core transmission links to accurately locate and correct abnormal transmission data.
Secure transmission protocols and secure token authentication are also enabled between units for reliable transmission.
DTS provides a visual management interface and wizards to guide you through establishing transmission links. You can easily create your own DTS instances in the console.
The DTS console displays the transmission status and progress, transmission performance, and other information for you to manage your transmission links.
To avoid link interruption resulting from network or system exceptions, DTS provides breakpoint recoverable transmission, and regularly monitors the statuses of all links. On detecting any link exception, DTS reacts to repair or restart the instance automatically. In cases where manual operation is needed, you can also directly fix the link and restart the instance in the DTS console.