This topic describes how to migrate an Oracle database to MaxCompute.

Background information

The database migration feature allows you to quickly upload all tables in an Oracle database to MaxCompute in an efficient and cost-effective manner. For more information, see Rules and restrictions.

Procedure

  1. Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. On the Workspaces page, find the target workspace and click Data Integration in the Actions column.
  2. On the Data Integration page, click Connection in the left-side navigation pane. The Data Source page appears.
  3. Click Add Connection in the upper-right corner and add an Oracle connection named clone_database for database migration. For more information, see Configure an Oracle connection.
  4. Go back to the Data Integration page and click Migrate Database in the left-side navigation pane.
  5. On the Migrate Database page, find the added Oracle connection and click Migrate Tables in the Actions column.
    The database migration settings page consists of three functional modules.
    No. Functional module Description
    1 Tables to migrate This module lists all the tables in the Oracle connection named clone_database. Selected tables will be migrated.
    2 Advanced settings You can configure the rules for converting the table names, column names, and data types between Oracle and MaxCompute data tables.
    3 Basic settings You can specify whether to synchronize full or incremental data on a daily basis, whether to upload data in one or more batches, and the synchronization frequency and efficiency. You can also view the migration progress and results of each table after committing the sync node.
    If you select Synchronize Incremental Data Daily, you must set the Incremental configuration mode parameter. Valid values:
    • Incremental field: Data Integration automatically generates a WHERE clause based on the specified field.
    • Where condition for incremental extraction?: Explicitly specify a WHERE clause to extract incremental data.
  6. Click Advanced Settings and configure conversion rules based on your needs.
  7. Set Sync Method to Synchronize All Data Daily.
    Note If a date column exists in your table, you can select incremental migration and configure the incremental data to be determined based on the date column. Data Integration will generate WHERE clauses based on the specified column and DataWorks scheduling parameters such as ${bdp.system.bizdate}.

    Select data upload in batches to protect the Oracle database from being overloaded. Configure Data Integration to start data synchronization for three tables every one hour from 00:00 each day.

    Click Commit Sync Node. Then, you can view the migration progress and results of each table.

  8. Find a related table and click View Node to view the node details.
    You have configured a node for migrating an Oracle connection named clone_database to MaxCompute. This node is run based on the specified schedule, daily by default. You can also create retroactive node instances to transmit historical data. The database migration feature of Data Integration significantly simplifies the initial configurations for migrating your data to the cloud and reduces data migration costs.