Welcome to the SQL Designer user guide!
The SQL Designer module is a Modelio extension dedicated to generating SQL script files and reverse SQL databases schemas.
We provides the following features:
-
Graphical representation and modeling of an SQL model:
-
At the conceptual level (data model)
-
At the logical level (table model)
-
Transformation of a data model into a table model, and of a table model into a data model
-
-
Generation of SQL script files from a table model (logical model)
-
Reverse of SQL databases schemas by direct connection to an existing database.
The SQL Designer interface
Note: In order to get the most out of SQL Designer, you must be familiar with Modelio. If this is not the case, have a look at the Modelio user guides and learn how to use our tool.