Data Modeling Tool for MS SQL Server Databases

DeZign for Databases is a database design and modeling tool for MS SQL Server databases. It is a graphical tool that simplifies data modeling tasks and enhances productivity. Using DeZign for Databases users can create and maintain databases and data models. Data models help you visualize complex data structures.

DeZign for Databases provides data modeling with standard modeling methodologies and notations (ER Diagrams with IDEF1X notation or IE notation), automatic SQL generation, powerful MS SQL Server reverse engineering capabilities to document and/or update existing databases, and customizable reporting capabilities.

design a mssql database data model

For Who?

DeZign for Databases can be used by database administrators and developers. It connects the database designers to the rest of the development team and business users. It enhances communication in your organization because you can share data models as well as present complex data structures in a format that is easy to understand and maintain.

Key Features

mssql diagram

Visual Data Modeling

DeZign for Databases offers a powerful ER diagram editor. Visually add entities (tables) and draw relationships between entities. You can also use subcategories, group boxes and text blocks in your diagram. The tool enables you to present your design at various levels of detail.

model and database synchronization for ms sql

Model/Database Synchronization

DeZign for Databases includes synchronization and comparison utilities to keep your model and your database synchronized. A database designer can compare a MS SQL Server database with a data model and visually see the differences. Differences can be moved from model-to-database or database-to-model. If model changes move into the database then a database synchronization script will be generated.

create or generate a mssql database

Forward Engineering

DeZign for Databases can generate output from your data model. It offers support for generating MS SQL Server databases. From the design, MS SQL Server specific definitions (DDL) are generated for all database objects (tables, views, triggers, procedures, constraints, indexes etc). This eliminates the process of manually writing complex SQL code.

reverse engineer a mssql database

Reverse Engineering

DeZign for Databases enables you to reverse engineer existing MS SQL Server database. You can reverse engineer MS SQL Server databases through a direct native connection or through a SQL DDL script. The result is a graphical data model. A subdiagram is optionally created per database schema when several schemas are imported at once. You reverse engineer a database when you want to create a new model for an existing database or when you want to compare (and synchronize) an existing database with your data model.

MS SQL Server database documentation

Database Documentation

Visualization and publication are the keys to communication and collaboration in database modeling. DeZign for Databases offers customizable reporting and printing capabilities. You can generate professional documentation for your MS SQL Server databases in MS Word, PDF or HTML formats. You can print out your diagram or export your diagram to an image file (gif, jpg, bmp, wmf).

support for multiple databases

Multiple Database Systems

DeZign for Databases supports multiple databases. You can create target DBMS specific models or database-independent models (with portable data types). You can create a database-independent model when you want to output your model to more than one target DBMS. You can also convert your model from one database system to another. Editable data type and function conversion rules are used for the translation.

large ms sql server model support

Large Model Management

DeZign for Databases helps you manage large data models through subdiagrams (subviews). Subdiagrams provide a focused view for individual data modelers, dividing the model into smaller, manageable subsets.

design ms sql server databases with a team

Teamwork

Development teams can work in parallel on a single model. DeZign for Databases' compare and merge models utility lets you merge different versions of the model. This utility reduces parallel development complexity.

Supported MS SQL Server Versions

DeZign for Databases can forward engineer and reverse engineer MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019 and 2022 databases.

Get Started Today

And see why tens of thousands of data modelers worldwide choose DeZign for Databases.

Try Out DeZign for Databases (14 days free trial)