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.

Project Update feature in Luna Modeler. Sample for SQL Server ERD.

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

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.

Details of detected changes

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

Generating detailed comparison reports

To generate a detailed HTML report, click the Generate report button on the Detected changes form. A new modal form opens. Select style, specify description and confirm your action.

Style for report.

The generated output will contain statistics as well as details of the detected changes.

Generated HTML report containing statistics and detailed description of detected changes.

See how to update ER Diagrams in Luna Modeler


Quick links

Download Buy Now!

Blog Categories
Blog by Platforms