Updated on 2023-11-14 GMT+08:00

Migrating Tables

Procedure

  1. On the Cluster Management page, click Job Management in the Operation column of the cluster and choose Table/File Migration > Create Job.
  2. Configure jobs at the source end and destination end.

  3. Configure source job parameters based on the type of the source database.

    Table 1 Source job parameters

    Parameter

    Example Value

    Schema/Table Space

    db_user01

    Use SQL Statement

    No

    Table Name

    APEX2_DYNAMIC_ADD_REMAIN_TEST

    WHERE Clause

    -

    Null in Partition Column

    Yes

  4. Configure the destination job parameters based on the destination cloud service.

    Table 2 Destination job parameters
    1. Parameter

    Example Value

    Schema/Table Space

    db_user01

    Auto Table Creation

    Non-auto creation

    Table Name

    apex2_dynamic_add_remain_test

    Clear Data Before Import

    Clear all data

    Import Mode

    COPY

    Import to Staging Table

    No

    Prepare for Data Import

    -

    Complete Statement After Data Import

    analyze db_user01. apex2_dynamic_add_remain_test;

  5. Mapping between source fields and destination fields.

  6. If the task fails to be configured, retry for three times, save the configuration, and run the task.

  7. The task is executed, and the data migration is finished.