Database Schema Comparison & HTML Reports

Comparison reports generation is part of the synchronization features in Luna Modeler. It is always necessary to compare the data model with the database. The report can then be generated from the overview of detected changes.

How to create comparison reports

Click on the Advanced button in the main toolbar. A sub-menu will appear from which you can select either Generate synchronization SQL or Update project from database.

Advanced button in Luna Modeler.

If you select Generate synchronization SQL, a window will appear in which you select on the right side the other database connection you created earlier. Click the Load Database and Detect Differences button to start the comparison process.

Settings and detection of database schema changes in Luna Modeler data modeling tool.

After the comparison is completed, you will see a list of changes.

The result of SQL database comparison. A list of detected differences is displayed.

Generating Documentation

To generate documentation, click the Report button in the Synchronization window.

Report button on the Synchronization form in Luna Modeler.

Select the path where the report should be saved and generate an HTML report with a list of changes. The report can be generated in multiple themes. Here you can see the dark theme.

HTML report generated by Luna Modeler. The report contains the result of SQL database schema comparison.

#

DATA MODELING TOOLS
DRAW Diagrams and
GENERATE Scripts
Download data modeling tools
Blog Categories
Blog by Platforms