Luna Modeler helps you design clean ER diagrams, generate SQL Server scripts, and improve your workflow – even if you’re new to data modeling.
Learn more about Luna Modeler
Luna Modeler is the perfect fit for database professionals, developers, DBAs, teachers, and anyone passionate about data modeling. If you’re looking for a modern, user-friendly, and budget-friendly tool, Luna Modeler is the ideal solution.
Download Luna Modeler
Frequently Asked Questions on Database Design for SQL Server
There are many tools available, ranging from expensive to free. If you’re looking for a modern tool that’s easy to install on Windows, macOS, or Linux, we recommend Luna Modeler. It has a number of features specific to SQL Server.
Absolutely. Luna Modeler can connect to your SQL Server instance and generate ER diagrams automatically. You can also visualize Azure SQL databases.
Yes. You can generate SQL scripts from ER diagrams created in Luna Modeler, including custom SQL blocks.
Luna Modeler offers the ability to export an ER diagram to PDF or image and also includes the ability to generate an interactive HTML report in a variety of styles and themes.
Everything you create stays with you. Luna Modeler does not store database connections or projects online. Your data is yours and everything is completely under your control.
Yes, Luna Modeler offers a 14-day fully functional trial for Windows, macOS, and Linux. You can download the trial from https://www.datensen.com
Key features of Luna Modeler
data modeling tool for SQL Server
Create database designs for SQL Server
Database design comes with cool features that let you visually define the structures of an MS SQL Server database. You can create SQL Server ER diagrams, set up tables, define views, triggers, procedures and user-defined types, map out relationships, and detail the specifics of SQL Server tables and columns.
Quick and comfortable database modeling for SQL Server
In Luna Modeler, all changes are saved immediately. You can edit objects in the sidebar or larger forms. Details of columns, indexes, etc., are available in expandable areas. If you change a property, you can instantly see how the SQL script changes.
Generate documentation for SQL Server Database Designs
When designing a database, you can organize SQL Server objects into diagrams, colorize items, add notes in HTML format, and connect objects using lines with custom endpoint graphics. You can also export diagrams to PDF, image or HTML.
Generate SQL scripts from your database designs
The generation of SQL scripts for database designs can be initiated by clicking a button on the main toolbar, which will immediately present a code preview.
You can also write templates and generate a custom output.
Visualize existing SQL Server structures
Connect to an existing SQL Server and reverse engineer the database. Secure SSH/SSL/TLS connections for visualization of cloud databases are supported in the Professional Edition.
Read about the visualization of existing databases
Learn how to visualize an Azure SQL Server database
Find out how to visualize SQL Server Express Database
Detect changes and update your projects
Connect to your database, compare the structure of your existing database with your project and generate a detailed HTML report or update your project easily.
Download
Luna Modeler
Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.