You can create a migration project in the Advanced Database & Application Migration (ADAM) console. This allows you to migrate schemas of 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 intelligently converting data types. This topic describes how to create a migration project.

Prerequisites

  • A database evaluation project is created. For more information, see Evaluate a database.
  • A destination database archive is created. For more information, see Create a database archive.
  • If you migrate data to a PolarDB-X 1.0 instance, you must first create a database and bind the database to an ApsaraDB RDS instance. The database must have the same name as a schema of the source database.

Procedure

  1. Log on to the Data Management (DMS) console V5.0.
  2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Database Transformation and Migration.
  3. On the Transform and Migrate DB page, click Create Migration Project.
  4. In the Create Migration Project panel, set the 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.
    Target library file Select the archive of the destination database.
    Note If no archive of the destination database is displayed, click Create Database Archive to create a destination database archive. For more information, see Create a database archive.
    Transformation Type The value is set to Online Transformation.
  5. Click Test Connectivity.
  6. After the connectivity test succeeds, click Create.
    Note If the migration project is not displayed on the Transform and Migrate DB page after you click Create, you can click 刷新 in the upper-right corner to refresh the page.
    After the status of the migration project changes to ACTIVE, the project is created.

What to do next

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