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.

Generate SQL Script for SQL Server

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.

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

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

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

About Luna Modeler

Luna Modeler is a data modeling tool for relational databases – SQL Server, PostgreSQL, MariaDB, MySQL and SQLite.

Key features

  • visual creation of ER diagrams for relational databases
  • support for database specifics (like composite types in PostgreSQL etc.)
  • easy-to-use user interface
  • various display modes
  • forward engineering & code generation
  • reverse engineering (for SQL Server, MariaDB, MySQL and PostgreSQL)
  • secure SSL/TLS connections to cloud based solution like Heroku Postgres etc.
Read the rest

Crow’s foot notation in ER diagram

Use crows foot notation to represent relationships between entities in an entity relational diagram. Entities are connected by lines, and symbols at the beginning or end of the line describe cardinality.

Relationship types and cardinality:

Symbols in crow’s foot notation

A crow’s foot graphics represents “many” or “infinite”.… Read the rest

What is Entity Relationship Diagram (ERD)?

Entity relationship diagram describes the structure of the database. The entity relationship diagram shows entities (tables in relational databases) and relationships between tables that exist in the database. For a good database design, it is very important to have an entity relationship diagram.

In an entity relationship diagram, the basic elements are:

  • Entities (tables)
  • Attributes (table columns)
  • Relationships (relationships between tables)

Why create entity relational diagrams?

Read the rest