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