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.