Data Modeling Tool for MS Azure DatabasesDeZign 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|
AudienceDeZign 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.
Visual Data ModelingDeZign 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 EngineeringDeZign 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 EngineeringDeZign 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 SynchronizationDeZign 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 DocumentationVisualization 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 ManagementDeZign 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 MergingDevelopment 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 SystemsDeZign 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|