All Products
Search
Document Center

Overview

Last Updated: Oct 15, 2021

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 Edition, ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, ApsaraDB RDS for PPAS, and AnalyticDB for PostgreSQL databases. The following versions are supported.

Note

ADAM supports Oracle Database 10g, 11g, 12C, and later.

  • PolarDB O Edition

  • PolarDB for PostgreSQL

  • PolarDB-X version 1.0 (Only schemas can be migrated)

  • 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, make sure 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:

    1. Log on to the ADAM console by using your Alibaba Cloud account.

    2. On the Transform & Migrate DB page, grant the relevant permissions to the RAM user.

Procedure

Online transformation
  1. Create a migration project: Create a migration project based on the evaluation result.

  2. Run a recheck: Check the permissions, plug-ins, and version of the destination database to ensure smooth migration.

  3. Optional. Verify the source database: Analyze the source Oracle database, track database changes, and update the migration project based on the database changes. To verify a migration project, make sure that the ADAM server can access the source Oracle database. If you skip this step, the migration project may not be created based on the latest data. In this case, you must collect and evaluate the database data again.

  4. 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.

  5. Optional. Compare the incremental data: Track the major changes to the data and schemas of your source database. This improves the migration efficiency of changed data definition language (DDL) statements.

  6. Migrate data: Use Data Transmission Service (DTS) to migrate data.