| Category |
Feature |
ModelRight for
Oracle |
Case
Studio/Toad Data Modeler 2.25 (Quest) |
DeZign for
Databases 4.1.3 (Datanamic) |
ERwin 7.01
(Computer Associates) |
| General |
|
|
|
|
|
| |
Undo/Redo |
Yes,
unlimited. |
No |
No |
Yes.
Unlimited. |
| |
Copy/Paste |
Yes.
Very advanced copy/paste. See documentation for details. |
Limited.
For instance columns, etc cannot be copied. |
Limited.
For instance relationships, columns, etc cannot be copied. |
Yes.
Kind of. Copy a view and no columns are copied. Copy a table with rolenamed
columns in it and different columns are copied, etc. |
| |
Drag/Drop |
Yes.
Very advanced drag/drop. See documentation for details. |
No |
No. |
No.
Or at least it doesn't seem to work. |
| |
Find |
Yes |
No |
Limited. |
No. |
| |
Transaction
Summary/Impact Analysis |
Yes. |
No |
No |
Yes. |
| |
ActiveX/Scripting |
Yes. |
Yes |
No |
Limited. It cannot be run from within the
application and it is not "generic". |
| |
XML
export |
Yes |
Yes |
No |
Yes. |
| |
|
|
|
|
|
| User Interface |
|
|
|
|
|
| |
Model
Explorer |
Yes |
Limited.
It shows only tables. |
Limited
in its scope. |
Yes. |
| |
Modeless
dialogs |
Yes |
No |
No |
No. |
| |
Hyperlinked
navigation |
Yes |
No |
No |
No. |
| |
On
Diagram Editing |
Yes
- extensive, names, datatypes, null option, Pk/nonPk, etc.. |
No. |
No |
Yes. |
| |
Barker
Notation |
Yes |
No |
No |
No. |
| |
IE
notation |
Yes |
No |
Yes |
Yes. |
| |
IDEF1X
notation |
Yes |
Yes |
Yes |
Yes. |
| |
Auto-Layout |
Yes |
Yes.
Kind of. |
Yes |
Yes. |
| |
Object
SQL preview. |
Yes. |
Yes. |
No. |
No. |
| |
|
|
|
|
|
| Modeling |
|
|
|
|
|
| |
Logical
Modeling |
No |
No. |
No. |
Yes. |
| |
Domains |
Yes
(nearly every object type) |
No. |
Limited.
Just for columns. No domains hierarchy. |
Limited
to columns. |
| |
Compare
with Model |
Yes |
No. |
No. |
Yes |
| |
Naming
options |
Yes |
No. |
Some
support. |
Yes |
| |
Model
Subsets |
Yes |
Limited.
It supports submodel that don't allow multiple views per subset. |
Limited.
It supports sub-diagrams but not model subsets with multiple views per
subset. |
Yes. |
| |
Key
Migration |
Yes.
Very advanced: key-based, user-defined. |
Limited.
One can end up with multiple columns of the same name!!! |
Limited.
No unification, property propagation, rolenaming, etc. |
Limited
- no User-defined migration. No referential constraints on Views. |
| |
Unification |
Yes |
No |
No |
Yes. |
| |
Rolenaming |
Yes |
No |
No |
Yes. |
| |
User
Defined Properties |
Yes |
No |
No |
Yes. |
| |
Model
Validation |
Yes |
Yes,
but only as part of Forward Engineer process. |
Yes. |
Yes. |
| |
Incomplete
Objects |
Yes |
No |
No |
No. |
| |
Versions
support |
No |
Yes |
Yes |
No
when standalone. Yes (when using Model Mart). |
| |
|
|
|
|
|
| Database |
|
|
|
|
|
| |
Multiple
database support |
No |
Yes |
Yes |
Yes. |
| |
Forward
Engineering |
Yes
(fully customizable) |
Yes |
Yes |
Yes.
Customizable using a proprietary script language. |
| |
Reverse
Engineering |
Yes.
Advanced with multiple filters. |
Limited.
We could not reverse engineer views for instance. Also, the filtering by
schema is just applied to tables. |
Yes |
Limited.
It doesn't reverse engineer tables based on types. |
| |
Database
Compare/Alter script |
Yes
(fully customizable) |
No |
No |
Yes
but we could not get it working in 7.0 release. We were not able to select the target
database as per documentation. Also its not customizable. |
| |
Oracle
Object-Relational support |
Yes |
No |
No |
No. |
| |
Views
& Materialized Views Management |
Yes |
No |
No |
Limited.
Any column based on expression will not be kept in sync with its referenced
objects. Also a lot of views are not properly parsed. |
| |
Function
Based Indexes |
Yes |
No |
No |
No.
At least it doesn't appear to work. |
| |
Bitmap
Indexes |
Yes |
Yes |
No |
Yes. |
| |
Partitions |
Yes |
No |
No |
Yes. |
| |
Advanced
Oracle Physical Properties |
Yes |
Some. |
No |
Yes. |
| |
Synonyms |
Yes |
No.
TDM supports synonyms, views, sequences, etc just as text objects with no
structure. |
No |
Yes. |
| |
Sequences |
Yes |
No. |
Yes |
Yes. |
| |
Syntax-colored
SQL editor with built-in SQL execution |
Yes |
No. |
No. |
No. |
| |
|
|
|
|
|
| Price |
|
$495
($295 - Introductory price) |
$479 |
$699 |
$3995
without Model Mart. |
|
|
|
|
|
|