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.
-
Integration with the Hibernate Designer module: Used in conjunction with the Hibernate Designer module, SQL Designer generates the database script, the Java data model and the Hibernate mapping files between the database and the data model.
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.