Key features of the database design tool for MS SQL Server
Draw ER diagrams
Define entity-relationship diagrams for SQL Server easily. and model your database visually.
Reverse engineer
Connect to your SQL Server database and visualize existing database structures.
Create documentation
Share your pixel-perfect diagrams in high-quality printable PDF format.
Generate scripts
Preview, generate and save SQL scripts for your SQL Server databases.
Create database designs for SQL Server
Database design features include a visual definition of MS SQL database structures. Visually design SQL Server ER diagrams, specify tables, sequences, draw relationships and define SQL Server table and column specifics.
Quick and comfortable database modeling for SQL Server
Create new objects with predefined settings. Change field positions using drag and drop. Add referenced columns to target tables automatically etc. Changes are propagated and saved immediately and in case you need to revert changes, use UNDO. A dark or light theme in UI is only a matter of your preference.
Keep your database designs
well documented
When designing a database, you can organize SQL Server objects into diagrams, colorize items, add notes in HTML format, connect objects using lines with custom end point graphics. You can also export diagrams to PDF or HTML.
Generate SQL scripts
Generate SQL scripts for your database designs. Click a button on the main toolbar and immediately see code preview.
You can also add custom code to BEFORE and AFTER sections and save scripts for whole your SQL Server database design or for just a single SQL Server table or relationship.
Reverse engineer existing structures
Connect to an existing SQL Server and reverse engineer database. SSH/SSL/TLS connections are supported in the Professional Edition.
Detect changes, generate report or 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.
Key benefits – SQL Server database design tool
Blueprint to your own product
A diagram can give you a clear model of your database structure and help you recognize errors. It’s like a blueprint to your house. You know what you are building, how to connect the pieces and you have the necessary documentation.
Efficient communication
A good database design allows all your team members or clients to understand the relationships among tables in your SQL Server structures in an effective manner.
Higher productivity
Database modeling activities helps you create your SQL Server databases visually, the work is faster, you can avoid typos and make changes quickly.
Purchase
Luna Modeler
You can use the same license key on Windows, Linux and MacOS.
EDU license for students and teachers is available for the Basic Edition.
