All Products
Search

This Product

    Data Transmission Service:Enable multi-table merging

    Document Center

    Data Transmission Service:Enable multi-table merging

    Last Updated:Jun 26, 2026

    When you use Data Transmission Service (DTS) for data synchronization or migration, DTS provides a multi-table merging feature if the target database is AnalyticDB for MySQL 3.0. This feature allows you to consolidate multiple tables that have identical structures in the source database and merge them into a single data table in the target database, which enables more efficient and convenient data migration and integration.

    Prerequisites

    You have created a migration or synchronization task with a target of AnalyticDB for MySQL 3.0, and have proceeded to the Configure Objects and Advanced Settings step. You can find the relevant configuration documents in the Synchronization Solution Overview or Migration Solution Overview.

    Usage notes

    • You cannot enable multi-table merging for tasks that have data verification enabled.

    • Incremental tasks with multi-table merging enabled do not support DDL operations. If you perform a DDL operation on the source database, it may cause data loss or task failure.

    Procedure

    This section shows how to enable multi-table merging for a DTS data synchronization instance.

    1. Navigate to the Configure Objects and Advanced Settings step and configure all parameters preceding the Merge Tables section.

    2. In the Merge Tables section, select Yes.

    3. Optional: For Set the value of __dts_data_source, select No.

      Note

      Customizing the tag column name and values is supported only for subscription instances.

    4. In the Source Objects pane, select the tables that you want to synchronize, and then click the 向右小箭头 icon to move them to the Selected Objects pane.

    5. In the Selected Objects pane, right-click a table to synchronize. In the Edit Table dialog box, modify the Table Name.

      Note

      The Table Name is the table's name in the destination database.

      The process is similar to changing the Table Name. In the Edit Table dialog box, you can change the table name to a target name (such as person_new), set a filter condition (which supports standard SQL WHERE clauses and applies to both full and incremental synchronization), select the DML operations to synchronize (insert, update, or delete), and select the columns to synchronize (such as p_name and p_id). When you are finished, click OK.

    6. Repeat the preceding step to modify the Table Name for all selected tables.

      Important

      You must specify the same Table Name for all tables that will be merged.

    7. Follow the on-screen instructions and reference documents to complete the remaining task configuration.

      If you selected Yes for Set the value of __dts_data_source in step 3, you must also set the Value of __dts_data_source in the Configure Database and Table Fields step.

      Note

      The value in the Value of __dts_data_source column must be unique for each table.

      On the Configure Database and Table Fields page, locate the Value of __dts_data_source column and enter a unique value for each source table. Other columns on this page include Schema Name, Table Name, Type (for example, partitioned table), Primary Key Column, and Distribution Key.