Core Features
Struct Migration
MySQL > MySQL: Supports automatic struct migration in which tables, views, functions, stored procedures, and indexes are used as objects for migration/synchronization.
Oracle > MySQL (unavailable during the public preview): Supports tables and indexes, eliminating the need to manually define DDL statements.
PostgreSQL > PostgreSQL: Supports tables, views, functions, stored procedures, and sequences.
Full Data Migration/Synchronization
DTS provides efficient and comprehensive full migration services for existing data. You can switch between the stream mode and the batch mode for full data migration/synchronization tasks based on your business requirements. The stream mode can be applied to a wider range of scenarios and works more stably than the batch mode because no primary key is required. The batch mode provides higher performance, but it requires a primary key and a certain memory size. DTS works in stream mode by default.
Incremental Data Migration/Synchronization
DTS monitors the incremental data generated in the source database in real time and continuously synchronizes the incremental data to the destination database. Incremental data migration allows you to migrate the data of an entire database without business interruptions, significantly reducing the downtime of your key business.
Precheck
DTS uses more than 30 migration/synchronization precheck items to troubleshoot issues at the earliest opportunity, significantly reducing the risks during migration.
ETL Processing
Name Mapping
DTS supports mapping at the levels of databases, tables, and columns. You can rename databases, tables, and columns in the destination instance for one or more migration objects at a time, which facilitates simplified operations.
Data Filtering
Row filtering: You can configure WHERE conditions based on your business requirements to filter data.
Column filtering: You can directly specify the columns to be migrated.
DML and DDL cleansing: You can filter the DDL or DML operations (INSERT/UPDATE/DELETE) for incremental data migration/synchronization.
Data Audit
Object Comparison
DTS supports quantitative comparison of objects such as indexes, tables, views, functions, and stored procedures between the source and destination databases after migration or synchronization.
Data Comparison
DTS compares the number of rows in the migrated or synchronized tables between the source and destination databases after migration or synchronization to ensure data integrity.
Migration Report
Migration Evaluation Report
When data migration is complete, DTS automatically generates a migration evaluation report. This report provides a panoramic view of the migration process, including the precheck status before migration, performance metrics during migration, and results of data audits and comparison after migration. DTS also provides the report in Word format for you to download.
Task Management
Start Task
After an instance is ordered, you can start a task based on your business requirements. If it is a pay-as-you-go instance, no fees are incurred until the first time a task starts.
Pause Task
You can pause a running task based on your business requirements. If a task is paused, data transmission will be temporarily interrupted. In this case, you can click Start Task to resume the task.
Edit Task
You can adjust the objects for migration or synchronization in a task by adding or deleting objects based on your business requirements. The adjustments take effect after the task restarts.
Note: You must pause a task before editing it.
Finishing a Task
For a migration task that is complete and for which data has been compared for consistency, you can finish the task to end the migration and close the data connection.
Note: After a task is finished, data transmission cannot be restarted. Please operate with caution.
Performance Monitoring
DTS collects and displays the data of traffic BPS, performance RPS, network latency, SQL response time (RT), and other key metrics in real time during migration/synchronization. This helps keep you updated with the status of migration or synchronization.
Monitoring and Alarms
You can customize the monitoring and alarm settings and create custom metrics.