1 Applicable Scenarios

This article is applicable for using Baidu AI Cloud Data Transmission Service DTS (hereinafter referred to as DTS) to migrate the data of the Oracle database instance to the destination MySQL instance.

2 Usage Restriction

• The versions of self-built Oracle database are 10g, 11g, 12c (PDB connection mode is required), 18c (PDB connection mode is required), 19c (PDB connection mode is required).
• The version of the MySQL database must be higher than or equal to 5.6.
• Incremental synchronization does not support DDL statements that synchronize relational databases.
• The migration of tables without a primary key is not supported.
• If you need to select both full and incremental migration, the source must not have materialized view logs related to the migration table; if you only select incremental migration, you need to create the materialized view logs related to the migration table on the source in advance.

3 Migration Preconditions

3.1 Environmental Requirements

• The Oracle instance as the migration source has been created.
• The MySQL instance as the destination of the migration has been created, such as: RDS for MySQL, self-built MySQL, etc.

3.2 Privilege Requirements

• Source: The account is required to have Oracle DBA privileges, and the user is guaranteed to create materialized view logs and obtain data operations.
• Destination: It only needs to meet the minimum requirements for the destination authority in each stage of structure migration, full migration, and incremental migration.

4 Operation Steps

4.1 Create a Migration Task

Enter the DTS list page and click [Create Data Transmission Instance].

After configuring the basic information of the instance, pay for the DTS instance.

4.2 Configuration Task

Return to the DTS list page, and you can see the DTS instance you just purchased, and the status is [Unconfigured].

Click [Configuration Task]

4.2.1 Connection Configuration

First, configure the upstream and downstream connection information of the data transfer task. You can choose a cloud database instance or self-built instance as needed. The source currently only supports self-built Oracle on the public network.

4.2.2 Select Migration Type and Migration Database Table

1.Check the "Migration Type" according to your needs: Structure migration, full migration, incremental migration; 2.Select the object to migrate in the "Source Object" box, and the object to migrate appears in the "Selected Object" box.

3.If you need to change the name of the migration object in the destination library, you can click the edit button on the right side of the object to rename it.

4.Click "Save and pre-check" to start pre-check

4.3 Pre-check and Start Migration

1.After a while, the page will display the pre-check results. 2.If the pre-check fails, you can view the specific failure reason for each check item, click the "Modify Migration Task" to modify the task and restart to initiate the pre-check.

3.If the pre-check is successful, click the "Open Task Now” to start the task.