Navicat Generating database structure synchronous SQL

As a bitter technical male, in the development of the time will often meet the program version upgrade, database structure changes. We need a quick way to get our customers updated from the old version database structure to the new version database structure as soon as possible. If we make a record of each change, it is a good thing, but if we neglect it, it will be disastrous. Looking for a long time, the internet also has a large database contrast software, most of them are written by foreigners, but also the flower beauty knife. Inadvertently found Navicat for MySQL has this function, not riding a donkey to find an donkey? Direct.

Method/Step

1. 1. Open Navicat for MySQL, find the tool, structure synchronization

2. 2, select the target database and the source database, the following will generate a series of structure synchronous SQL, but can not directly copy, so we take the third step

3. 3, right button all check

4. 4. After the third step is completed, right-click the check command to see the replicable structure of synchronous SQL

Navicat Generating database structure synchronous SQL