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.
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.
A list of available database connections will appear, select the one you want to use and click 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.
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.
The generated output will contain statistics as well as details of the detected changes.
See how to update ER Diagrams in Luna Modeler