DeZign for Databases
Data modeling for database professionals.
Visualize database structures to understand your database, create new databases or reverse-engineer existing databases to modify, document, analyze, and optimize.

Data Modeling Tool for MS Azure Databases

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

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

 > Download trial      > Purchase DeZign for Databases      > Learn more      > Take the screenshot tour

ms azure model


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 models as well as present complex data structures in a format that is easy to read and understand.

Key Features

Visual Data Modeling

DeZign for Databases offers a powerful ER diagram editor. Visually add database objects such as entities 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.

Forward Engineering

DeZign for Databases can generate output from your data model. It offers support for generating MS Azure databases. From the design, Azure specific definitions (DDL) are generated for all database objects (tables, views, triggers, procedures, constraints, indexes etc). You don't have to write complex SQL code anymore.

Reverse Engineering

DeZign for Databases enables you to reverse engineer existing MS Azure database. You can reverse engineer Azure databases through a direct native connection or through a SQL DDL script. The result is an entity relationship diagram (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.

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 Azure 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.

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 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).

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.

Model Merging

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.

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.

     > Learn More