How to create model from an existing database using Navicat? (Mac)

0
0
191 days ago, 130 views
Navicat provides a powerful tool to create models. To convert existing tables and views into a model, you can control-click a database or schema and select “Reverse Database to Model...” from the popup menu. Alternatively you can control-click the selected tables or views and select ”Reverse Table to Model...” or ”Reverse View to Model...” from the popup menu. When you’ve finished designing the model, you can put it back to the existing database. Select “Synchronize to Database” in “File” from the menu. In Navicat Premium, you can convert the database type for the model. When you create a model for Oracle schema, you can change it to a model for MySQL database. Select “Model Conversion” in “File” from the menu and choose the desired database type and version. Navicat will convert fields to relevant field types, according to server type. You may need to change the SQL syntax of the views after the conversion. To retrieve SQL from the model, select “Export SQL” in “File” from the menu. Edit properties on the appropriate tabs.

SPONSORS

Join Thatshow.com on Facebook

Looking for delicious recipes anyone?

Check out
Clipchef.com,
our free video recipe sharing website.

SPONSORS

SPONSORS