Complete the comparison of MySQL database structure in 10 seconds

In the production environment, we always cause master-slave non-synchronization for one reason or another, or the test environment needs to be synchronized with the production environment. Using Navicat structure synchronization tool, we can not only find out the differences in library structure, but also selectively compare create, modify, drop, etc., which is very humanized, so let's take a look at how it works.

First, select the tool and synchronize the structure in the main interface of Navicat, and you will see the following screen:

Select the source and target servers, select the databases that need to be synchronized, select the desired running options, and check to continue with errors.

After clicking on the comparison, there will be a synchronization process, which is only a comparison, not really synchronized yet. Click the run synchronization button in the lower right corner to synchronize the source database table structure to the target database table structure.