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, conditional generation and collaboration with the merge projects utility.
| Feature |
Standard Edition |
Professional Edition |
Expert Edition |
| 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 |
| Internal editor with syntax highlighting. | X | X | X |
| Grid based editing in list of attributes, indexes, triggers etc. | X | X | X |
| Copy diagram objects to clipboard as image. | X | X | X |
| To-do list. | 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 |
| 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 |
| Drag and drop database objects. | X | X | X |
| Model validation. | X | X | X |
| Attribute color coding. | X | X | X |
| Gradiency for diagram objects. | X | X | X |
| Automatic propagation of foreign keys (optional). | X | X | X |
| Attribute packages are reusable sets of attributes for consistent attribute definitions. | X | X | X |
| Multiple display modes (entities, all attributes, key attributes etc). | 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/owner when importing a database. | X | X | X |
| Version Management | |||
| Automatically archive a version of the model when your 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 |
| Database | |||
| 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 |
| 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 | |||
| Compare and/or merge projects. | - | - | 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.
