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
DatabaseMigration Plan: generates a migration plan based on the database evaluation results.
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.
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.
Data Migration: uses Alibaba Cloud Data Transmission Service (DTS) to migrate data.
Step 1: Migration Plan
Create Migration Projectdialog box appears, as shown in the following figure.
- You must set Evaluation DB first.
- 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:
126.96.36.199/24 and 188.8.131.52/24
Step 2: Verification
- This step helps you identify which objects in the source database have been modified since the most recent data collection.
- You must make sure that the ADAM server can access the source Oracle database.
- 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
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:
184.108.40.206/24 and 220.127.116.11/24.
2.2 View the verification results
Verification Resultspage 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
migration/revision. You can click Start in the corresponding section to start
table schema migrationor
non-table schema migration. You can click Stop to stop the
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
Schema Revisiontab, as shown in the following figure.
Status: Schemas in the
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
Migration Reporttab, as shown in the following figure.
Step 4: Data Migration
schema migration/revision is complete, you can begin the
You must start the
data migration from the DTS console.