Help Center> Data Admin Service> User Guide> GaussDB(for MySQL)> Table Structure Comparison and Synchronization
Updated on 2023-12-13 GMT+08:00

Table Structure Comparison and Synchronization

This section describes how to check the structure difference by comparing and synchronizing table structures when you perform a migration or verification.

Prerequisites

To create a table structure comparison and synchronization task, you need to toggle on Save SQL first so that DAS can store your data. If you do not toggle on Save SQL, you cannot create table structure comparison and synchronization tasks.
Figure 1 Enabling the function of saving SQL statements

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Structure Management > Table Structure Comparison and Synchronization.

    Search for tasks by task status and view task details.

    Figure 2 Structure management

  7. On the displayed page, click Create Task in the upper left corner.
  8. On the displayed page, specify the source database, target instance, target database, error tolerance, and synchronization type. Click Next.

    Figure 3 Creating a task

  9. View comparison objects and click Compare.
  10. View the comparison progress. In the comparison item list, click View Logs in the Operation column to obtain comparison details. You can also click Download DDL as needed.

    Figure 4 Viewing logs

  11. Click Next. On the Synchronize page, view basic information about this comparison task, such as the source instance, source database, target instance, target database, and synchronization type, and specify the items to be synchronized.
  12. Skip synchronization items that may cause high risks and click Synchronize.

    Figure 5 Synchronizing items

  13. After synchronization is complete, click View Logs in the Operation column to obtain comparison details. You can download DDL as required.