
Blog articles


How to update ER diagrams in Luna Modeler

What’s new in versions 6
Luna Modeler
Support for SQL Server – Luna Modeler version 6 contains significant improvements that will be appreciated by all our users. We know from your feedback that you missed SQL Server database support the most. We are happy to announce the addition of SQL Server support!

Comparison reports – Many of you are interested in using advanced features such as project comparison, synchronization, etc.… Read the rest

SQL Server indexes
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

How to generate SQL script for SQL Server
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.

Generation settings
You can control how the script will be generated on the Generation settings tab

Order of items
The order in which the objects will be in the resulting SQL script can be modified on the Order items tab.… Read the rest

Updating SQL Server projects
How to update your SQL Server ER diagrams
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

Visualization of existing SQL Server databases
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

SQL Server database design
Quick start guide for SQL Server database design.
1. New project
To create a new project, click New on the main toolbar and select the SQL Server project type.
2. Add tables
Basic database objects can be added to your project/diagram by clicking the appropriate icon on the main toolbar.… Read the rest

What’s new in versions 5.2
We focused on the possibility of exporting to PDF. Since all our applications contained two basic themes, dark and light, it was possible to use the visualization in that theme to export to PDF. In case you wanted to print the PDF document afterwards, the dark theme was print intensive and the light theme had an extra background color or less visible edges of graphic objects.… Read the rest

ER Diagram tool for macOS
Is macOS your preferred operating system? And are you interested in creating ER diagrams for your databases? Try Luna Modeler – a desktop application for designing database structures for
- SQL Server,
- PostgreSQL,
- MySQL,
- MariaDB,
- SQLite and
- also for creating logical models.
It is a tool that can run on any operating system, i.e.… Read the rest