Updated on 2023-04-26 GMT+08:00

Skipping a Synchronization Task

In a synchronization task, if the destination is a GaussDB(DWS) instance, DDL operations that are performed on the source database in the incremental synchronization phase will also be performed on the GaussDB(DWS) instance. If the destination GaussDB(DWS) instance does not support the DDL statement, the synchronization task becomes faulty.

To solve this problem, you can skip the DDL statement to continue the synchronization task after rectifying the fault based on the synchronization log information.

Procedure

  1. Contact GaussDB(DWS) technical support to execute this statement with the same semantics in the destination database and the statement must comply with the syntax of the destination database.
  2. On the Data Synchronization Management page, locate the task you want to skip and click Skip DDL in the Operation column.

    Figure 1 Skip DDL

  3. After confirming that statement was executed on the destination database, click Yes to skip the error and continue the synchronization task.

    Figure 2 Skip DDL