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 a 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.

How to compare the project with the database?

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.

detected changes

In case you created the project manually, you can still compare your project with the database. Just create a database connection on the Connections page. Then navigate to your project and click on the Update button and choose Select connection.

update - select connection

A list of available database connections will appear, select the one you want to use and click Update project.

Update project using selected connection.

Again, a form with an overview of the changes will be displayed. To view the details, click on the arrow to the left of the object type. The name of the object and information on whether it is a new, deleted or modified object will be displayed.

Detected changes and details.

The next step is simple, either you update your project or you don’t.

SQLite & Import from files

We have changed the user interface for the ability to import SQLite databases. Previously the import was available from the Projects page. However, since version 5.1 includes the Project update feature, we have added the ability to save the database connection/path among other “connections”. This makes it easy to find the original database. Additionally, you can use the option to use this “connection” for Project update.

To create a connection, go to page Connection and click the Create new connection button. New form opens. All that is needed is the name of the connection and the path to the file. Then you can work with this database just like with others, such as PostgreSQL or MariaDB.

Connection for SQLite
Connect and load SQLite structure
Update SQLite database project

#

Quick links

Free Trial Buy Now!