Visualize database structures to understand your database, create new databases or reverse-engineer existing databases to modify, document, analyze, and optimize. DeZign for Databases is an intuitive data modeling tool for developers and DBA's that can help you model, create and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular databases.

DeZign for Databases offers a sophisticated visual data modeling environment for database development that makes your database development process much easier. The tool reduces faults in database development and improves your productivity. You can visualize database structures to understand your database, create new databases or reverse-engineer existing databases to modify, document, analyze, and optimize.

The tool is extremely easy to use. Whether you are a beginner or an expert database modeler, you will find your way in the tool very easily. DeZign for Databases provides all the features you expect in a professional database modeling and design tool.

Visual Database Modeling
DeZign for Databases offers a intuitive visual interface that allows you to accurately design your database. It uses entity relationship diagrams (ERDs) to graphically design databases and produces high quality database data models, enabling you to present your design at various levels of detail.

Forward and Reverse Engineering
forward engineering a database
Forward engineering. DeZign for Databases can generate databases directly from your data models (ER-diagrams). For SQL databases, the SQL DDL scripts to create your database will be generated. For non SQL databases, the physical database files will be generated directly. You can control what will be generated. Generate individual parts of your model. Generate tables, foreign keys, indexes, domains, sequences, procedures, triggers and views.

reverse engineer a database
Reverse engineering. Derive a graphical data model from existing databases, for both relational and big data platforms. You can import an existing database by connecting to the database directly or by importing a SQL DDL script. Your complete database will be imported including tables, foreign keys, sequences, triggers, procedures and views. While reverse engineering, the software analyzes the database to find relationships not expressly defined to the database.

Database/Model Synchronization
Our data modeling product offers bi-directional compare and synchronize functionality for all synchronization use cases: model-to-database, model-to-script, database-to-model, script-to-model, model-to-model. When any change is made to either the model or database, DeZign for Databases provides a comprehensive comparison of all differences. Changes can be moved from model-to-database or database-to-model. With the comparison options you can control what will be seen as a difference.

Model-Driven Collaboration
If you need to develop large models with many modelers, you might prefer to store your model in a (server-based) repository database. The Datanamic Repository is a central repository database to store your data models. With the Datanamic Repository more than one user can work on the same data model. You can connect to the Datanamic Repository with the Teamwork Edition of DeZign for Databases.

Database Specific Models or Database-Independent Models
DeZign for Databases supports modeling for a specific target DBMS (physical) and it supports database-independent modeling with portable data types (logical).

Customizable Model Reports
Customizable data model reports with different levels of detail can be generated. Descriptions and other relevant information will be exported to HTML, MS Word or PDF.

Intuitive Modeling Environment
The industry standard modeling processes are followed and the tool has a well-designed user interface which decreases the user's learning curve.

Better Database Designs
You can validate a model for errors any time during the design process. During validation, DeZign for Databases checks to make sure the elements in your model are correct and complete. Reusable objects (domains and attribute packages) and name templates promote consistent database object definitions.

Model Maintenance
Diagram management. DeZign for Databases extends your modeling power with subdiagrams. A project is a set of one or more subdiagrams that contains the specification of an entire data model. You can break a large or complex model into smaller, easier to maintain subdiagrams. Any object can exist in any number of subdiagrams.

Object browser. The Object Browser provides an additional method for creating and modifying model objects. Rather than presenting a picture of the model in the traditional diagram window manner, the Object Browser provides an organized, ordered view of the model and its contents. You can create, navigate and modify a model in the Object Browser.

Labeling support. With the labeling functionality, you can organize the objects in your project into meaningful groups. This way you can quickly and easily filter and report on the data that is of most interest to you. You can add more than one label to a database object.

Database Development Lifecycle
Reverse engineering. You can use DeZign for Databases' reverse engineering capabilities to create a data model diagram of your current database system. You can import an existing database by connecting to the database directly or by importing a SQL DDL script. Your complete database will be imported including tables, foreign keys, sequences, triggers, procedures and views. While reverse engineering, the software analyzes the database to find relationships not expressly defined to the database.

Forward engineering. DeZign for Databases can generate databases directly from your data models (ER-diagrams). For SQL databases, the SQL DDL scripts to create your database will be generated. For non SQL databases, the physical database files will be generated directly. You can control what will be generated. Generate individual parts of your model. Generate tables, foreign keys, indexes, domains, sequences, procedures, triggers and views.

Database/model synchronization: Our data modeling product offers bi-directional compare and synchronize functionality for all synchronization use cases: model-to-database, model-to-script, database-to-model, script-to-model, model-to-model. When any change is made to either the model or database, DeZign for Databases provides a comprehensive comparison of all differences. Changes can be moved from model-to-database or database-to-model. With the comparison options you can control what will be seen as a difference. You fine-tune the comparison engine even more with custom comparison rules. DeZign for Databases also automatically generates alter scripts to update any database.

Only for V.I.P