What types of data migration does DTS support?

• DTS supports three types of data migration: Structure migration, full data migration, and incremental data migration.
• The source databases with migration supported by DTS include the public network self-built database with public IP, BCC self-built database, and RDS instance; the target database can be BCC self-built database and RDS instance.

What contents will DTS structure migrate?

Currently, DTS structure migration only supports the migration of tables and views and does not support the migration of storage processes, triggers, and custom functions.

What is the principle of DTS incremental migration and how to ensure incremental real-time migration?

The incremental data migration is to synchronize the data added during the source database migration to the target database in real-time. If both full data migration and incremental data migration are selected when creating the data migration task, static data in the source database will be migrated to the target database first, and then incremental data will be synchronized to the target database.

Does the DTS migration process affect the source database and delete the data in the source database?

The DTS migration actually replicates the data in the source database, without deleting the data in the source database, or affecting the data in the source database. If the user selects both full data migration and incremental data migration, in order to guarantee the consistency of migrated data, DTS will add a read-only lock to non-transaction tables without a primary key in the source database, and release the read-only lock after the migration is completed. During migration, tables with a read-only lock cannot be written in, and other tables are not affected.

In the DTS migration process, for BCC self-built database or RDS instance, is it through private network or external network?

During the migration, the BCC self-built database and the RDS instance will go through the private network no matter cross-region or not, and no public network traffic is needed.

In the DTS migration process, for BCC self-build database or RDS instance, is it through private network or external network?

The DDL operations on the source database during the migration are supported, but continuous DDL operations in a short time are not supported, e.g., above 2 consecutive DDL operations in 1 minute.

Does DTS support data migration of the BCC self-built database or RDS instance within VPC?

Supported, but the public network is required. So public IP is required for BCC self-built database or RDS instance.

Can different databases under two RDS instances under the same account be migrated?

Yes. The DTS supports the database table mapping feature and can realize data migration between databases with different names under different RDS instances.

In the DTS migration process, will the table data of the same name in the target library be overwritten?

No. The check will be performed before DTS migration, and this task cannot be executed if there's a table with the same name in the target database. However, if the database of the same name is written in the source database during the migration, after migration, the data in the target database will be overwritten, so please be cautious to enter the source database data during the migration.

Why the following privileges: ["SELECT", "LOCK TABLES", "REPLICATION CLIENT"] are required before data migration by users?

Because there is no relevant authorization for the migration account.

• If it is a migration between Baidu RDS, the migration account must have read or write privileges on the migrated objects.
• For a public network or a self-built one, the migration account needs to have relevant privileges, which can be granted manually or operated through the console.