Use the Navicat tool to synchronize the MySQL database structure.

Use the Navicat tool to synchronize the MySQL database structure.

Navicat is a fast, reliable, and cost-effective database management tool designed to simplify database management and reduce system management costs. Navicat provides up to 7 languages for customers to choose from and is recognized as the world's most popular database front-end user interface tool.
Navicat has multiple product members who can manage and develop local or remote MySQL, SQL Server, SQLite, Oracle, and PostgreSQL databases. Because the MySQL database is introduced in this article, we need to use the Navicat For MySQL tool under Navicat. Navicat For MySQL download link.
We usually use a development version and a formal version of the database in the development project. How can we quickly synchronize the database table structure modified in the development version to the official version? If you manually modify fields or attributes, it is too troublesome and easy to omit. With the Navicat tool, you can quickly implement direct database synchronization, including structure synchronization and data synchronization. The following describes how to use Navicat For MySQL to synchronize the structure between MySQL databases.

1. Open Navicat For MySQL2. create a database connection to connect to the local database server or connect remotely. Create a local connection.

You can name the connection name on your own for easy identification. After filling in the address, username, password, and so on, you can click test connection to create a connection. If the connection is successful, a prompt is displayed.

3. After the connection is successful, select the tool> structure synchronization to synchronize the database under the connection.

4. Select the source and target of the data to be synchronized. The source is the reference database for structure synchronization, and the target is the database for which the structure to be modified for synchronization. Select the items to be compared. You can choose to only synchronize tables, or only synchronize views or stored procedures. After setting the database, click the Compare button to compare the structure of the two databases and find out the differences.

5. as shown in the comparison result, we can see which tables, views, functions, and other structures are different from the source object and target object lists above. The specific differences can be seen through the following query statement. Select the query statement to be executed and click Run to modify it synchronously.

6. The running result is displayed in the Information log. If a query fails to be executed, it is displayed in red and can be manually modified. If no error occurs, the structure synchronization is completed. You can check in the database whether the two tables have the same structure.