Blog articles

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.

SQL server - connection properties

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

Updating projects and ER diagrams

Project update

In Luna Modeler you can compare your project to the structure that is in the database and easily update your project. See what objects no longer exist in the database, what objects have been added to the database, and what objects are different.

You can also do the comparison to see what objects you have added to your project, what objects you have removed from your project, or what objects have been modified.… Read the rest

SSH or SSL/TLS database connections

In Luna Modeler and Moon ModelerProfessional 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:

SSH settings

SSH settings

SSL/TLS settings

SSL or TLS settings

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

Updating SQLite projects

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.

How to update your SQLite ER diagrams created from scratch

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

Updating PostgreSQL projects

How to update your PostgreSQL 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.

update button on toolbar

A form will appear with a summary of the changes and you can accept the changes or not.… Read the rest

What’s new in versions 5.1

Luna Modeler

We are pleased to introduce a new version of Luna Modeler, which includes the first of many advanced functionalities. The Project Update feature is here!

Project update

You can now compare your project to the structure that is in the database and easily update your project. See what objects no longer exist in the database, what objects have been added to the database, and what objects are different.… Read the rest