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

   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.