If you have activated Alibaba Cloud databases, you can transform and migrate your databases online by taking the steps : Database Collection --> Source Database Portrait --> Suggestions --> Target DB Evaluation

  1. DatabaseMigration Plan: generates a migration plan based on the database evaluation results.

  2. Verification: compares the cloud migration plan with the source Oracle database to determine which objects are new, modified, or deleted to help you update your cloud migration plan. This step is optional. To verify a migration plan, the ADAM server must be able to access the source Oracle database. If you skip this step, the migration plan will not be generated based on the most recent data, and you will need to collect and evaluate the database data again.

  3. Schema Migration/Revision: migrates as many objects to the destination database as possible. ADAM evaluates, verifies, and provides solutions for incompatible objects. You can revise errors based on their corresponding error messages and try again.

  4. Data Migration: uses Alibaba Cloud Data Transmission Service (DTS) to migrate data.

Step 1: Migration Plan

Click Create Migration Project, and the Create Migration Project dialog box appears, as shown in the following figure.

Notes:

  1. You must set Evaluation DB first.
  2. You must then select Online Transformation.

Set required parameters. Click Create to create a project and generate a cloud migration plan.

You must add the following IP addresses to the whitelist of the destination database: 39.100.131.0/24 and 47.241.17.0/24

Step 2: Verification

Notes:

  1. This step helps you identify which objects in the source database have been modified since the most recent data collection.
  2. You must make sure that the ADAM server can access the source Oracle database.
  3. This step is optional. If you skip this step, ADAM will migrate data based on the results of the most recent collection and evaluation. If the data has not been modified or the modifications are negligible, you can skip this step. If the data has been modified significantly, you must re-collect and re-evaluate data to migrate the database.

2.1 Configure the source database

After you create a project and generate a cloud migration plan, click the Online Transformation tab. On the tab that appears, click View in the Actions column corresponding to the project. The Source Database Details dialog box appears, as shown in the following figure.

1. Skip the verification.

2. After you configure the source database, you must click Test to ensure that the ADAM server can access the source database, and then click Start Verification. Add the following IP addresses to the whitelist of the source database: 39.100.131.0/24 and 47.241.17.0/24.

2.2 View the verification results

After you click Start Verification, the Verification Results page appears, as shown in the following figure.

After the verification is complete, click Next Structure Migration.

Step 3: Schema Migration/Revision

3.1 Schema migration

After the verification is complete, you can start the migration/revision. You can click Start in the corresponding section to start table schema migration or non-table schema migration. You can click Stop to stop the schema migration.

After the migration is complete, if the migration of any schemas failed, you can click Revise in the Actions column corresponding to the schemas to go to the Revise page.

3.2. Schema revision

Click Schema Revision to go to the Schema Revision tab, as shown in the following figure.

Status: Schemas in the FAILED or MANUAL state must be manually revised. You can click Revise in the Actions column corresponding to a schema to revise it, as shown in the following figure.

** You can perform the following operations on this page: **

[Revise]: revises the current DDL statement.

[Reset]: restores the initial DDL statement.

[Ignore]: skips the migration of the DDL statement.

3.3 Migration report

Click Migration Report to go to the Migration Report tab, as shown in the following figure.

Step 4: Data Migration

After schema migration/revision is complete, you can begin the data migration.

You must start the data migration from the DTS console.