Help Center > > User Guide> GaussDB(for MySQL) DB Instance Management (Development Tool)> Structure Management> Table Structure Comparison and Synchronization

Table Structure Comparison and Synchronization

Updated at: Jun 09, 2021 GMT+08:00

Scenarios

When you perform a migration or verification, you can check the structure difference by comparing and synchronizing table structures.

Procedure

  1. On the top menu bar, choose Structure Management > Table Structure Comparison and Synchronization.

    Search for tasks by task status and view task details.

    Figure 1 Structure management

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

    Figure 2 Creating a task

  4. View comparison objects and click Compare.
  5. 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 3 Viewing logs

  6. Click Next. On the Synchronize page, view the 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.
  7. Skip synchronization items that may cause high risks and click Synchronize.

    Figure 4 Synchronizing items

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel