Reverse engineering means retrieving information about the database structure. It is about finding out what objects exist in the database, such as tables, columns, views, procedures, etc., and what relationships exist between these objects. Based on this information, it is possible to generate an ER diagram in which the relationships can be clearly displayed.
Visualization of existing databases
To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select target platform, e.g. PostgreSQL and enter the connection details.
When you are finished, click the Save Connection button. Your new PostgreSQL connection will appear in the list of all database connections.
Loading existing database structures
To start the reverse engineering process and to create a project with an ER diagram, navigate to your connection and click Connect and load the existing database structure. This will start a process that will result in a new project with an ER diagram.
As a result, you will see the ER diagram for your database structure. If you reverse engineered multiple schemas, you might find it useful to enable the Display schema mode.
In the Professional edition of Luna Modeler, you can also split the main diagram to multiple sub-diagrams by schemas.
If you wish to visualize another database, either create a new connection or create a copy of an existing connection.
