MySQL database structure synchronization using NAVICAT tools

Navicat is a fast, reliable and affordable database management tool designed to simplify database management and reduce system administration costs. Navicat is recognized as the world's most popular database front-end user interface tool, offering up to 7 languages for customers to choose from.
Navicat has a number of product members that can be used to manage and develop native or remote MySQL, SQL Server, SQLite, Oracle, and PostgreSQL databases. Because the MySQL database is described in this article, we're going to use Navicat's navicat for MySQL tool. Navicat for MySQL download link.
When we develop the project, we usually use a development version and a full version of the database, in the development version of how the database table structure can be quickly synchronized to the official version? If you manually modify the field or property, it is too cumbersome, and easy to omit, with the Navicat tool, you can quickly realize the database directly synchronization, including structure synchronization, data synchronization and so on. Here's how to use Navicat for MySQL to synchronize fabric between MySQL databases.

1. Open Navicat for MySQL2. Create a database connection that connects to the local database server or to a remote connection. Create a local connection.

The connection name can be arbitrarily named, easy to identify on the line. After filling in the address user name password and so on, you can click the test connection, to see the ability to create a connection, if successful will pop the window prompt.

3. Once the connection is successful, select tools → fabric synchronization to synchronize the database under the connection.

4. Select the source and destination of the data that you want to synchronize, the source is the reference database for fabric synchronization, and the target is the database that you want to modify to synchronize the structure. and select the items you want to compare. You can choose to synchronize only the tables, or only the views or stored procedures, and so on. You can compare the structure of these two databases and find out the difference by clicking the button.

5. Compare the results as shown, you can see in the above list of source and target objects that the structure of the table or view or function is different, the specific difference can be seen through the following query statement. Select the query statement you want to execute and click Run to synchronize the changes.

6. The results of the operation will be displayed in the Infolog, and if unsuccessful queries appear, they will appear in red font and can be modified manually. If there is no error, the structure is completed synchronously. Can be viewed in the database, the parts of the two tables to be synchronized whether the structure is already consistent.

MySQL database structure synchronization using NAVICAT tools