Compare Editions

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. new	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. new	-	-	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. new	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. new	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. new	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. improved	X	X	X
Load and save report templates. new	X	X	X
Database
Support for more than 15 databases.	X	X	X
Editor for data type conversion rules. new	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). new	-	-	X
Compare model to SQL scripts and update database. new	-	-	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. new	-	-	X
Collaboration
Compare and/or merge projects. new	-	-	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.