|
Feature
|
Standard Edition
|
Professional Edition
|
Expert Edition
|
|
Visual Data Modeling
|
|
Create database models (ER-diagramming)
|
X
|
X
|
X
|
|
IDEF1X Notation
|
X
|
X
|
X
|
|
Crow's Feet Notation
|
X
|
X
|
X
|
|
Subdiagrams
|
X
|
X
|
X
|
|
Autolayout diagram
|
X
|
X
|
X
|
|
Drag and drop database objects
|
X
|
X
|
X
|
|
Model validation
|
X
|
X
|
X
|
|
Data Dictionary
|
|
Entities with attributes, indexes, constraints
|
X
|
X
|
X
|
|
Identifying and non-identifying relationships
|
X
|
X
|
X
|
|
Many-to-many relationships
|
X
|
X
|
X
|
|
Subcategories
|
X
|
X
|
X
|
|
Triggers
|
X
|
X
|
X
|
|
Views
|
X
|
X
|
X
|
|
Procedures/functions
|
X
|
X
|
X
|
|
Sequences/generators
|
X
|
X
|
X
|
|
Begin/End database and table scripts
|
X
|
X
|
X
|
|
Table options and index options
|
X
|
X
|
X
|
|
Reusable Objects
|
|
Attribute packages
|
X
|
X
|
X
|
|
Domains
|
X
|
X
|
X
|
|
Reporting
|
|
Print diagram
|
X
|
X
|
X
|
|
Configurable HTML, PDF, MS Word reports
|
X
|
X
|
X
|
|
Export diagram as image (JPG, GIF, BMP, WMF)
|
X
|
X
|
X
|
|
Miscellaneous
|
|
Open file format (XML)
|
X
|
X
|
X
|
|
Internal editor with syntax highlighting
|
X
|
X
|
X
|
|
To-do list
|
X
|
X
|
X
|
|
Switch to another target database
|
X
|
X
|
X
|
|
Versions
|
|
Archive current data model
|
X
|
X
|
X
|
|
Switch to an old version
|
X
|
X
|
X
|
|
Re-generate database for an old version
|
X
|
X
|
X
|
|
Compare data model versions
|
-
|
-
|
X
|
|
Automatically create/archive versions
|
-
|
-
|
X
|
|
Forward Engineering
|
|
Generate database from data model
|
X
|
X
|
X
|
|
Generate drop script
|
X
|
X
|
X
|
|
Reverse Engineering
|
|
Reverse engineer from many popular DBMS systems
|
-
|
X
|
X
|
|
Smart Relationship Finder to infer non declared relationships
|
-
|
X
|
X
|
|
Update model from database
|
-
|
X
|
X
|
|
Compare model with current database
|
-
|
X
|
X
|
|
Database Modification
|
|
Update database based on changes made in the data model (generate intelligent alteration code)
|
-
|
-
|
X
|
|
Supported Databases
|
|
Multiple databases are supported.
|
X
|
X
|
X
|
|
|
Standard Edition
|
Professional Edition
|
Expert Edition
|
