Articles related to database visualization in Moon Modeler – a database design tool for both relational and noSQL databases and GraphQL.
If you have created a project using reverse engineering, you have already saved the database connection and the project remembers this connection. So just click on the Update button and choose Update with default connection. The comparison will happen immediately.
A form will appear with a summary of the changes and you can accept the changes or not.… Read the rest
All database connections are available in the Connections section. 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 SQL Server and enter the connection details.
When you are finished, click the Save Connection button.
Your new SQL Server connection will appear in the list of all database connections.… Read the rest
In Luna Modeler and Moon Modeler – Professional editions, you can create both basic database connections and secure SSH/SSL/TLS database connections. To learn how to create a new database connection, see Database connections.
To create a secure connection, just set the options on the SSH and SSL/TLS tabs:
Once you create this type of connection, the item will be highlighted in green in the list of connections, so you can easily distinguish a secure connection from a classic connection.… Read the rest
You can easily visualize existing SQLite databases in Luna Modeler. And in case there are changes in the database, you can use the Project Update feature to update your project and the ER diagram.
If you modeled your database design from scratch and then created the SQLite database, do the following: Create a connection on the Connections page.… Read the rest
If you have created a project using reverse engineering, you have already saved the database connection and the project remembers this connection. So just click on the Update button and choose Update with default connection. The comparison will happen immediately.
A form will appear with a summary of the changes and you can accept the changes or not.… Read the rest
Luna Modeler is a data modeling tool for relational databases – SQL Server, PostgreSQL, MariaDB, MySQL and SQLite.
Quick start guide for MongoDB schema design in Moon Modeler.
The following text explains how to design a new database structure for MongoDB.
To create a new project in Moon Modeler click the New item on the toolbar.… Read the rest
When you create a new index for MongoDB collection in Moon Modeler, the Index Assistant window will appear.
Indexes can be defined easily. Just select the fields, either from the drop down element:
or by typing the field name directly. The auto-completion feature is available for you.
Click the Add button to insert the field to the index.… Read the rest
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 draw an ER diagram in which the relationships can be clearly displayed.… Read the rest
To manage your database connections, click the Connections button on the main toolbar.
Click the button Create a new connection to open a modal form. Select the database platform, enter the connection name and connection details.
The settings are specific to each supported platform.
If you want to list all available databases, go back to tab Server and click Load databases.… Read the rest