Navicate Data Modeler New table is not synchronized to the database (memo)

Navicat Data Modeler is one of my favorite database modeling tools, in the process of use, always avoid the inevitable encounter some problems.

1. Let's say we've imported some models from the database, and then we've created two new models, by default, as shown in:

We choose our new table, click the right mouse button, in the pop-up menu select "Design Table", I generally operate is

The red box of these four tabs, you will ask me why the last "options" card is not selected, then the focus is coming. The information in the "options" is more important to the table structure of our synchronization model. In our new table, this content is generally empty (of course we did not fill in the information, the contents are empty). For example, we have two new tables, one of which is left blank in "Options" in the design table, one to fill in:

The contents of the "t_pricing_order" option are empty:

The contents of the "t_pricing_details" option are not empty

Note: The model name is the database name that we imported into the database

, we then click on the head of the "Tools", "Sync to the database", in the popup dialog, we use the mouse to click on the red circle

, Next, we select the target connection we want to synchronize, select the "Target" connection and click the "Compare" button, then go to:

And you will find that our "T_pricing_order" does not show here, yes, exactly what we did not give us the new "t_pricing_order" table, when designing the table, without giving it the "options" content. Then we fill in the "Options" content for "T_pricing_order".

, click "OK", then we do the same action above, "Sync to the database", we will find:

, when we click on the source object with a red or blue table, the changes below will also be highlighted, we select the data to be synchronized, after we click "Run Query", we can synchronize our own new table into the MySQL database.

This is my own use of navicate Data Modelerl when I encounter my new table, I can not sync to the database problems, I hope to help people who encounter the same problem.

Navicate Data Modeler New table is not synchronized to the database (memo)