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
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/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.