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.
- 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.
- Log on to the ADAM console.
- In the left-side navigation pane, click Transform & Migrate DB.
- On the Transform and Migrate DB page, click Create Migration Project.
- 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
Note Only Online Transformation is available.
- 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.
- Click Test Connectivity.
- After the connectivity test succeeds, click Create. Note After a migration project is created, you can click in the upper-right corner to refresh the Transform and Migrate DB page.
- After the status of the project changes to
ACTIVE, click Details.