|
|
5.1
|
5.0
|
4.x
|
3.x
|
| Visual Data Modeling |
| Create database models (ER-diagramming) | X | X | X | X |
| IDEF1X Notation | X | X | X | X |
| Crow's Feet Notation | X | X | X | X |
| Autolayout diagram | X | X | X | X |
| Drag and drop database objects | X | X | X | X |
| Model validation | X | X | X | X |
| Subdiagrams | X | X | X | - |
| Groupboxes | X | X | X | - |
| Text areas | X | X | X | - |
| Improved autolayout diagram | X | X | - | - |
| Attribute coloring | X | X | - | - |
| Data Dictionary |
| Entities with attributes, indexes, constraints | X | X | X | X |
| Identifying and non-identifying relationships | X | X | X | X |
| Many-to-many relationships | X | X | X | X |
| Subcategories | X | X | X | X |
| Triggers | X | X | X | X |
| Views | X | X | X | X |
| Procedures/functions | X | X | X | X |
| Sequences/generators | X | X | X | X |
| Table options | X | X | X | X |
| Begin/End database scripts | X | X | X | X |
| Begin/End table scripts | X | X | X | X |
| Begin/End alter table scripts | X | X | - | - |
| Begin/End drop scripts | X | X | - | - |
| Index options | X | X | X | - |
| Index expressions | X | X | - | - |
| Function based indexes | X | X | - | - |
| Index column sort options | X | X | - | - |
| Object naming templates | X | X | X | - |
| Object naming tool | X | X | X | X |
| Manage schemas/owners | X | X | - | - |
| Reusable Objects |
| Attribute packages | X | X | X | X |
| Domains | X | X | X | X |
| Domain usage overview | X | X | - | X |
| Reporting |
| Print diagram (scalable) | X | X | X | X |
| Export diagram as image (JPG, GIF, BMP, WMF) | X | X | X | X |
| Generate HTML reports | X | X | X | X |
| Configurable HTML, PDF, MS Word reports | X | X | X | - |
| Generate MS Word reports | X | X | X | - |
| Generate PDF reports | X | X | X | - |
| Reports for subdiagrams | X | X | X | - |
| Improved report formatting | X | X | - | - |
| PDF export settings | X | X | - | - |
| Miscellaneous |
| Open file format (XML) | X | X | X | X |
| To-do list | X | X | X | X |
| Internal editor with syntax highlighting | X | X | X | - |
| Vista compatible | X | X | - | - |
| Grid based editing | X | X | X | - |
| Object browser | X | X | X | X |
| Object browser with object numbering | X | X | - | - |
| Copy diagram objects to clipboard as image | X | - | - | - |
| Copy and paste database objects between projects | X | - | - | - |
| Database Conversions |
| Switch to another target DBMS | X | X | X | X |
| Automated data type conversion | X | X | X | X |
| Customizable data type conversion with conversion rules | X | X | - | - |
| Customizable system function conversion with conv. rules | X | X | - | - |
| Data Model Versions |
| Data model version manager | X | X | X | - |
| 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 | - |
| Automatically create/archive versions | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Enhanced display of compare results | X | X | - | - |
| Database |
| Generate database from data model | X | X | X | X |
| Generate drop script | X | X | X | X |
| Reverse engineer from many popular DBMS systems with native database connection | X | X | X | - |
| Reverse engineer from a SQL file | X | X | X | - |
| Smart Relationship Finder to infer non declared relationships | X | X | X | - |
| Update database based on changes made in the data model (generate intelligent alteration code) | X | X | X | - |
| Update model from database | X | X | - | - |
| Schema/owner support | X | X | - | - |
| Selectively apply changes when updating model with database | X | X | - | - |
| Oracle 7, 8, 9, 10 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| Oracle 11 |
| Generate database (Forward Engineering) | X | X | - | - |
| Reverse engineer with native database connection | X | X | - | - |
| Reverse engineer database with SQL script | X | X | - | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | X | X | - | - |
| Update model from database | X | X | - | - |
| MS SQL Server 6.5, 7, 2000, 2005 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| MS Access 97, 2000 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | - | - | - | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| MS Access 2003, 2007 |
| Generate database (Forward Engineering) | X | X | - | - |
| Reverse engineer with native database connection | X | X | - | - |
| Reverse engineer database with SQL script | - | - | - | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | X | X | - | - |
| Update model from database | X | X | - | - |
| MySQL 3, 4, 5 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| InterBase 5, 6, 7 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| PostgreSQL 7, 8 |
| Generate database (Forward Engineering) | X | X | X | - |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| Firebird 1.5, 2 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| IBM DB2 Universal DB 7, 8 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | - | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | X | - |
| Database modifications (Alter database) | X | X | X | - |
| Update model from database | X | X | - | - |
| NexusDB V2 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| dBase |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | - | - | - | - |
| Compare data model versions | - | - | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| DBISAM 4 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | - | - | - | - |
| Compare data model versions | - | - | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| ElevateDB |
| Generate database (Forward Engineering) | X | X | - | - |
| Reverse engineer with native database connection | X | X | - | - |
| Reverse engineer database with SQL script | X | X | - | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| FoxPro |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | - | - | - | - |
| Compare data model versions | - | - | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| Paradox |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | X | X | X | - |
| Reverse engineer database with SQL script | - | - | - | - |
| Compare data model versions | - | - | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| Informix |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | - | - | - | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| MaxDB |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | - | - | - | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| Sybase ASE 11, 12 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | - | - | - | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
| Pervasive 8, 9 |
| Generate database (Forward Engineering) | X | X | X | X |
| Reverse engineer with native database connection | - | - | - | - |
| Reverse engineer database with SQL script | X | X | X | - |
| Compare data model versions | X | X | - | - |
| Database modifications (Alter database) | - | - | - | - |
| Update model from database | - | - | - | - |
