Articles related to Moon Modeler – a data modeling tool for both relational and noSQL databases.
To add a new index to a database table, edit your table, navigate to tab Indexes and click + Add Index.
Then add columns to the index. Click +Add Column to Index to display a dropdown with a list of available column names. Pick a column and then specify other index properties.… Read the rest
To generate SQL scripts from your SQL Server project click the SQL Script icon on the main toolbar. New modal opens. Click Save Script and select a location where the file should be stored.
You can control how the script will be generated on the Generation settings tab
The order in which the objects will be in the resulting SQL script can be modified on the Order items tab.… 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
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
Quick start guide for SQL Server database design.
To create a new project, click New on the main toolbar and select the SQL Server project type.
Basic database objects can be added to your project/diagram by clicking the appropriate icon on the main toolbar.… 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
How to create ER diagram of PostgreSQL database running in Heroku? With Luna Modeler, the process is simple. Just create a database connection, retrieve the information from Heroku Postgres and create a project containing the ER diagram. But let’s start one step at a time.