Compare Editions

See also: Supported Databases.

Short summary of the differences between the editions

Standard Professional Expert
  • ER Diagramming
  • Generate databases
  • Generate documentation
  • Folder-based projects (for Git)
  • Reverse-engineer existing databases
  • Update model from database
  • Update database from model
  • Access to Datanamic Repository
  • ER Diagramming
  • Generate databases
  • Generate documentation
  • Folder-based projects (for Git)
  • Reverse-engineer existing databases
  • Update model from database
  • Update database from model
  • Access to Datanamic Repository
  • ER Diagramming
  • Generate databases
  • Generate documentation
  • Folder-based projects (for Git)
  • Reverse-engineer existing databases
  • Update model from database
  • Update database from model
  • Access to Datanamic Repository

Detailed list of features for each edition

Feature Standard Professional Expert

General

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

Visual Data Modeling

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

Subdiagrams Management

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

Version Management

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

Reporting

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

Databases

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

Collaboration

Folder-based projects (for storage in Version Control Systems such as Git)-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 to the repistory.--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.

Try Out DeZign for Databases (14 days free trial)