Navicat generate database with updated database structure synchronization

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

2, select the target database and the source database, the following will generate a series of structure synchronous SQL, so we take the third step

For example, you have a data, you want to copy the structure of data to a new test.

A. Build test first.

B. Then, the source database, fill in the data. Target database, fill in test

3. Then point the alignment.

4. You can see the comparison in the check box, then run the query. Structure synchronization is complete.

5. If the data also need to be synchronized, point, data Synchronization. You can preview it before synchronizing.

It's quite simple.

Here are the illustrations.

Http://jingyan.baidu.com/article/bad08e1e8e689b09c85121ed.html

Navicat generate database with updated database structure synchronization