This topic describes how to migrate and transform databases online.
Supported database types
Advanced Database & Application Migration (ADAM) allows you to migrate data from on-premises Oracle databases to PolarDB-O, ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, ApsaraDB RDS for PPAS, and AnalyticDB for PostgreSQL databases. The following versions are supported.
PolarDB-O databases
ApsaraDB RDS for MySQL
Version 5.6
Version 5.7
Version 8.0
ApsaraDB RDS for PostgreSQL
Version 10.0
Version 11.0
Version 12.0
AnalyticDB for PostgreSQL
Version 4.3
Prerequisites
Before you migrate or transform a database online, you must ensure that your account has sufficient permissions.
If you are using an Alibaba Cloud account, skip this step.
If you are using a RAM user, perform the following steps:
Log on to the ADAM console by using your Alibaba Cloud account.
On the Transform & Migrate DB page, grant the relevant permissions to the RAM user.
Procedure
Create a migration project: Create a migration project based on the evaluation result.
Run a recheck: Check the permissions, plug-ins, and version of the destination database to ensure smooth migration.
Verify the source database: Track database changes and update the migration project based on the database changes. This step is optional. To verify a migration project, the ADAM server must access the source Oracle database. If you skip this step, the migration project will not be created based on the latest data. Then, you will need to collect and evaluate the database data again.
Migrate and revise schemas: Migrate objects to the destination database as possible as you can. ADAM evaluates and verifies the objects and provides solutions for incompatible objects. You can troubleshoot issues based on the error messages and try again.
Compare the incremental data: Track the major changes to the data or schemas of your source database. This improves the migration efficiency of changed DDL statements.
Migrate data: Use Alibaba Cloud Data Transmission Service (DTS) to migrate data.