You can create a migration project in the Advanced Database & Application Migration (ADAM) console. Then, you can migrate data from a source database to a destination database based on the 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. This topic describes how to create a migration project.

Prerequisites

  • The source database is evaluated. For more information, see Evaluate a database.
  • A database evaluation project is created. For more information, see Manage a database profile.
  • A destination database archive is created. For more information, see Create a database archive.
  • 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 panel, set the required parameters.
    Parameter Description
    Project Name Enter the name of the migration project.
    Evaluate DB Select the database evaluation project.
    Solution Details Select a migration solution.
    Destination Database Select the archive of the destination database.
    Transformation Type
    • Online Transformation: ADAM allows you to migrate data from on-premises Oracle databases to databases such as PolarDB for Oracle. For more information, see Overview.
    • Offline Transformation: For more information, see Offline transformation and migration.
    Note Only Online Transformation is available.
  5. Click Test Connectivity.
  6. After the connectivity test succeeds, click Create.
    Note After a migration project is created, you can click 1 in the upper-right corner to refresh the Transform and Migrate DB page.
  7. After the status of the project changes to ACTIVE, click Details.

What to do next

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