Help Center > > User Guide> TaurusDB for MySQL 8.0 Database Management (Standard Edition)> Structure Management> Table Structure Comparison and Synchronization

Table Structure Comparison and Synchronization

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

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

Prerequisites

You have logged in to the DAS console.

Procedure

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

    You can filter tasks based on the task status and view task details.

  2. Click Create Task.
  3. On the displayed page, set the task information, select the base database, target DB instance, and target database, select the fault tolerance options, and set the synchronization type. Click Next.
  4. View the comparison objects and submit the comparison.

    You can also cancel the comparison as required.

  5. View the comparison progress. In the comparison item list, click View Log to obtain the comparison details. You can download DDL.
  6. During the comparison, click Next. You can obtain the basic information about the task, such as the base DB instance, base database, target instance, target database, and synchronization type. You can set the synchronization items in the synchronization item list.
  7. Skip the synchronization items with relative high risks as required and execute the synchronization.
  8. After the synchronization is complete, click View Log to obtain the comparison details. You can download all DDL.

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