FC2Video

With Navicat Data Modeler, you can synchronize tables and views from a physical model to a database or export them to a script file.

In this tutorial, we will show you both ways to transfer model objects.

Assume we have imported some tables and views from a PostgreSQL schema into a physical model, made a few changes and added a new table.

Then we will transfer the model into a MySQL database. To change server type of a model, select "Model Conversion" from the "File" menu and choose the desired database type and version. Navicat Data Modeler will convert fields to relevant field types, according to the server type. You may need to change the SQL syntax of the views after the conversion.