Compare Editions
See also: Supported Databases.
Short summary of the differences between the editions
| Standard | Professional | Expert |
|
|
|
Detailed list of features for each edition
| 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 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 |
| Export data dictionary to CSV files. | 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 (See list of supported 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 | |||
| Folder-based projects (for storage in Version Control Systems such as Git) | - | X | X |
| 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)