Using NAVICAT to achieve MySQL database structure comparison and synchronization

In the production environment, we always because of this or that causes the master to never synchronize, or the test environment to synchronize with the production environment, using the NAVICAT structure Synchronization tool, not only can find the library structure differences, but also for create, modify, drop and other selective comparison, Very humane, so together to see how the operation.

First in the Navicat main interface selection tool, structure synchronization, you will see the following screen:

650) this.width=650; "title=" 1.png "src=" Http://s2.51cto.com/wyfs02/M01/84/92/wKioL1eVf0vDV3Q1AAsn3Mk_ Wxk295.png-wh_500x0-wm_3-wmp_4-s_3802536579.png "alt=" Wkiol1evf0vdv3q1aasn3mk_wxk295.png-wh_50 "/>

Select the source and destination server, select the database you want to synchronize, select the desired run option, and tick continue with the error encountered.

650) this.width=650; "title=" 2.JPG "style=" Float:none; "src=" http://s2.51cto.com/wyfs02/M01/84/92/ Wkiol1evfovsoobxaaetwjw451e265.jpg-wh_500x0-wm_3-wmp_4-s_2814337630.jpg "alt=" Wkiol1evfovsoobxaaetwjw451e265.jpg-wh_50 "/>

After clicking on the alignment, the synchronization process will occur, which is only a comparison, not really synchronized. Click the Run Sync button in the bottom right corner to synchronize the source database table structure to the target database table structure.

650) this.width=650; "title=" 3.JPG "style=" Float:none; "src=" http://s2.51cto.com/wyfs02/M01/84/92/ Wkiol1evfouwmmweaagoxh-m3fg192.jpg-wh_500x0-wm_3-wmp_4-s_1719477625.jpg "alt=" Wkiol1evfouwmmweaagoxh-m3fg192.jpg-wh_50 "/>

This article is from the "Age volt" blog, please make sure to keep this source http://suifu.blog.51cto.com/9167728/1829552

Using NAVICAT to achieve MySQL database structure comparison and synchronization