You can create a migration project in the Advanced Database & Application Migration (ADAM) console. Then, you can migrate data from an Oracle database to a destination database based on database evaluation results. The migration project maximizes the compatibility between the source and destination databases by converting data types. ADAM also provides a schema migration tool that automatically converts data types based on the migration project.

Prerequisites

  • The source database is evaluated. For more information, see Evaluate databases.
  • A destination database instance is created.
  • If you migrate data to a PolarDB-X V1.0 instance, you must first create a database and bind it to an RDS instance. The database must have the same name as the schema on the instance.

Procedure

  1. Log on to the ADAM console.
  2. In the left-side navigation pane, click Transform & Migrate DB.
  3. On the Transform and Migrate DB page, click Create Migration Project.
  4. In the Create Migration Project dialog box, enter a project name in the Project Name field, select a database from the Evaluate DB drop-down list, and select Solution Details.
    Select a solution
  5. In the following example, the destination database resides in the China (Zhangjiakou) region.
    Note
    • If you can access the destination database over a private network, you do not need to configure a public IP address. For information about how to add a private IP address to the destination database whitelist, see Configure the whitelist.
    • You must add the following CIDR blocks to the destination database whitelist: 39.100.131.0/24,47.241.17.0/24,149.129.255.0/24,47.254.192.180,47.89.251.0/24,47.245.13.0/24,47.75.108.0/24.
    Destination Database
    • Instance Region: the region where the destination database instance resides.
    • PolarDB-OConnected VPC: the VPC of the PolarDB-O Connected VPC.
    • Instances: the ID of the destination database instance.
    • Host IP Address: the public endpoint of the destination database.
    • Database Name: the name of the destination database.
    • Encoding Method: the encoding method of the destination database. This parameter is optional.
    • Port Number: the public port of the destination database.
    • Username: the username of a privileged account or the administrator account used to log on to the destination database. If you migrate data to a PolarDB-X V1.0 instance, specify the name of the destination database as the username.
    • Security Token: the password of the account.
  6. Select Online Transformation as the transformation type.
  7. Click Test Connectivity to perform a test. After the test succeeds, click Create.
  8. After the status of the project changes to ACTIVE, click Details.
    Click Detail

What to do next

After the migration project is created, ADAM automatically performs a precheck. For more information, see Run a precheck.