EN | NL | DE
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.

Robust and Easy to Use Database Design and Modeling Tool

er diagram, relational data model, erd

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.

dezign for databases features

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.

visual data modeling

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.

compare and synchronize a data model and a database

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.

model-driven collaboration for database developers

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.

Supported Databases

DeZign for Databases supports more than 15 databases including Oracle, MySQL, MS SQL Server, MS Access, DB2, Azure and PostgreSQL. A complete list of supported databases can be found in the supported databases overview.

supported databases native
customer quote

"We've been a Datanamic customer years. We switched away from a well-known competitive data modeling tool because we just couldn't justify the expense and complexity of that high-end tool any longer. DeZign for Databases provides all the functionality we need, at a fraction of the cost. DeZign for Databases is easy to use, and Datanamic has been very responsive to our issues and suggestions. We're very pleased and happy we made the switch."

Doug Newton, Sr. Mgr, Business Applications/Data Architecture
MathWorks

Screenshots

Main window with Object Browser and Pan and Zoom window.

IDEF1X notation.

Synchronize your data model and your database.

Edit the attributes of an entity.

Preview of the SQL that will be generated.

Work in a team and add your project to a central repository.

Over 20,000 organisations large, small and across every industry rely on DeZign for Databases.

Pricing

DeZign for Databases' features vary by product edition. DeZign for Databases is available in four editions to accommodate your data modeling and database maintenance needs.

Standard
$ 259

for a single user license

  • ER Diagramming
  • Generate databases
  • Generate documentation
  • Reverse-engineer existing databases
  • Update model from database
  • Update database from model
  • Database-independent models
  • Collaborate
Professional
$ 599

for a single user license

  • ER Diagramming
  • Generate databases
  • Generate documentation
  • Reverse-engineer existing databases
  • Update model from database
  • Update database from model
  • Database-independent models
  • Collaborate
Expert
$ 899

for a single user license

  • ER Diagramming
  • Generate databases
  • Generate documentation
  • Reverse-engineer existing databases
  • Update model from database
  • Update database from model
  • Database-independent models
  • Collaborate
Teamwork Edition
$ 999

for a single user license

  • ER Diagramming
  • Generate databases
  • Generate documentation
  • Reverse-engineer existing databases
  • Update model from database
  • Update database from model
  • Database-independent models
  • Collaborate

All prices are for the perpetual license of DeZign for Databases for one user (license). Once you purchase the software, no annual renewal is required. Upgrade Protection is optional.

Not sure which DeZign for Databases edition is right for you or your organisation?

Tech specs

Operating System: Windows 10/8.1/8/7/Vista/XP     Memory: 1 GB minimum (2 GB recommended)     Hard Disk: At least 20 MB of free disk space

Get Started Today

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

Save with Bundles

If you buy our software in bundles you save a great deal of money on the price of the individual database tools.