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.

Compare Editions

See also: Supported Databases.


  • Standard Edition for visual data modeling and database generation.
  • Professional Edition for visual data modeling, database generation, reverse engineering of existing databases and updating your data model by comparing it to an existing database.
  • Expert Edition for visual data modeling, database generation, reverse engineering of existing databases, support for all model/database synchronization use-cases, database-independent modeling and conditional generation.
  • Teamwork Edition for visual data modeling, database generation, reverse engineering of existing databases, support for all model/database synchronization use-cases, database-independent modeling, conditional generation and access to the repository database for working in teams.

Feature Standard Professional Expert Teamwork Edition


Copy and paste and drag and drop within or between models. XXXX
Undo-support. XXXX
Find objects by name or other object properties. XXXX
Open file format (XML). XXXX
Editor with syntax highlighting. XXXX
Grid based editing in list of attributes, indexes, triggers etc. XXXX
Labeling database objects to organize your data model. XXXX
To-do list. XXXX
Global search and replace (with regular expressions). XXXX

Visual Data Modeling

ER diagramming with support for Crow's Feet and IDEF1X notation. XXXX
DBMS-specific data models. XXXX
Database-independent data models. Forward engineer one model to multiple databases. --XX
Define entities, attributes, domains, views, indexes, procedures, sequences, triggers, relationships. XXXX
Identifying and non-identifying relationships. XXXX
Auto layout of objects in diagram. XXXX
Dynamic highlighting of related objects. XXXX
Drag and drop database objects. XXXX
Model validation. XXXX
Attribute color coding. XXXX
Automatic propagation of foreign keys (optional). XXXX
Attribute packages (reusable sets of attributes for consistent attribute definitions) XXXX
Multiple display modes (entities, all attributes, key attributes etc). XXXX
Pan and zoom window ("birds-eye" view of diagrams). XXXX
Name templates for database objects like constraints, foreign key columns, indexes etc. XXXX
Naming tool for batch renaming of objects. XXXX
Manage indexes on keys. XXXX

Subdiagrams Management

Subdiagrams can be created to represent objects related to given subject area.XXXX
Create subdiagrams for selected objects.XXXX
Automatically create a subdiagram for each schema.-XXX

Version Management

Automatically archive a version of the model when you forward or reverse engineer.XXXX
Compare model versions.XXXX
Manually archive current model.XXXX
Switch between archived model versions.XXXX


Print diagram (scalable).XXXX
Export diagram as image (JPG, GIF, BMP, WMF).XXXX
Generate configurable HTML (navigable), PDF, MS Word database/model documentation.XXXX
Load and save report templates.XXXX


Support for more than 15 databases. XXXX
Editor for data type conversion rules. XXXX
Switch to another target database. XXXX
Generate database from data model. XXXX
Generate DDL from data model. XXXX
Generate drop script. XXXX
Import databases through native database connections. -XXX
Import SQL scripts (DDL). -XXX
Creates a model upon completing a reverse engineering of a database or script file. -XXX
Smart Relationship Finder to infer non declared relationships. -XXX
Compare model to database and update model. -XXX
Compare model to SQL script and update model. -XXX
Define custom comparison rules. -XXX
Compare model to database and update database (generate intelligent alteration code).--XX
Compare model to SQL scripts and update database. --XX
Compare model versions and generate intelligent alteration code. --XX
Conditional generation. A conditional generation directive causes the schema generator to conditionally suppress the generation of portions of the model. --XX


Access to the Datanamic Repository.---X
Commit changes to the repository.---X
Get latest version of your model from the repository.---X
Conflict resolution when committing changes.---X
Controlled access to models via user profiles and access levels.---X

Please note that modify/alter database functionality and compare versions functionality is not supported for all target databases. Please check the Supported Databases page to see if that functionality is available for your database.

Try DeZign for Databases for free

Start building better databases today.