DeZign for Databases
The Ultimate Data Modeling Tool
Database Design Tool
Standard: $ 259
Professional: $ 499
Expert: $ 899
Upgrade to version 9

Compare Editions

See also: Supported Databases.

Summary:

  • 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
Edition
Professional
Edition
Expert
Edition
Teamwork
Edition
General
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
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
Reporting
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
Database
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
Collaboration/Teamwork
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.