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.
Feature | Standard | Professional | Expert |
General | |||
Copy and paste and drag and drop within or between models. | X | X | X |
Undo-support. | X | X | X |
Find objects by name or other object properties. | X | X | X |
Open file format (XML). | X | X | X |
Editor with syntax highlighting. | X | X | X |
Grid based editing in list of attributes, indexes, triggers etc. | X | X | X |
Labeling database objects to organize your data model. | X | X | X |
To-do list. | X | X | X |
Global search and replace (with regular expressions). | X | X | X |
Visual Data Modeling | |||
ER diagramming with support for Crow's Feet and IDEF1X notation. | X | X | X |
DBMS-specific data models. | X | X | X |
Database-independent data models. Forward engineer one model to multiple databases. | X | X | X |
Define entities, attributes, domains, views, indexes, procedures, sequences, triggers, relationships. | X | X | X |
Identifying and non-identifying relationships. | X | X | X |
Auto layout of objects in diagram. | X | X | X |
Dynamic highlighting of related objects. | X | X | X |
Drag and drop database objects. | X | X | X |
Model validation. | X | X | X |
Attribute color coding. | X | X | X |
Automatic propagation of foreign keys (optional). | X | X | X |
Attribute packages (reusable sets of attributes for consistent attribute definitions) | X | X | X |
Multiple display modes (entities, all attributes, key attributes etc). | X | X | X |
Pan and zoom window ("birds-eye" view of diagrams). | X | X | X |
Name templates for database objects like constraints, foreign key columns, indexes etc. | X | X | X |
Naming tool for batch renaming of objects. | X | X | X |
Manage indexes on keys. | X | X | X |
Subdiagrams Management | |||
Subdiagrams can be created to represent objects related to given subject area. | X | X | X |
Create subdiagrams for selected objects. | X | X | X |
Automatically create a subdiagram for each schema. | - | X | X |
Version Management | |||
Automatically archive a version of the model when you forward or reverse engineer. | X | X | X |
Compare model versions. | X | X | X |
Manually archive current model. | X | X | X |
Switch between archived model versions. | X | X | X |
Reporting | |||
Print diagram (scalable). | X | X | X |
Export diagram as image (JPG, GIF, BMP, WMF). | X | X | X |
Generate configurable HTML (navigable), PDF, MS Word database/model documentation. | X | X | X |
Load and save report templates. | X | X | X |
Databases | |||
Support for more than 15 databases. | X | X | X |
Editor for data type conversion rules. | X | X | X |
Switch to another target database. | X | X | X |
Generate database from data model. | X | X | X |
Generate DDL from data model. | X | X | X |
Generate drop script. | X | X | X |
Import databases through native database connections. | - | X | X |
Import SQL scripts (DDL). | - | X | X |
Creates a model upon completing a reverse engineering of a database or script file. | - | X | X |
Smart Relationship Finder to infer non declared relationships. | - | X | X |
Compare model to database and update model. | - | X | X |
Compare model to SQL script and update model. | - | X | X |
Define custom comparison rules. | - | X | X |
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/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.