Column filtering

This topic describes how to perform column filtering in OceanBase Migration Service (OMS).

Procedure

1. Create a data synchronization task and proceed to the Select Synchronization Objects step.

   For more information, see the topics about data synchronization tasks of the corresponding data source types.

2. After you select the synchronization objects and mapping method, move the pointer over the target object in the Target Object(s) list in the Select Synchronization Scope section and click Settings.

3. In the Settings dialog box, toggle on the switch next to Select Columns.

   Notice

   If you select all or no columns, OMS will synchronize all columns.

4. In the Select Columns section, select the columns to be synchronized.

   You can also enter keywords in the search box for fuzzy matching to quickly find the columns you want to synchronize.

5. Click OK.

6. Complete subsequent task settings as prompted.