Product comparison matrix

We've listed what we felt were the most important features in a Database Modeling software program and put ModelRight side by side with the leaders in the industry. We think you'll find it interesting.

Product Comparison
Feature	ModelRight 2	ER/Studio 7.5	ERwin 7.2
General
Undo/Redo	unlimited	limited to 64 actions. Also, a lot of actions cannot be undone (model merge for instance),. Pretty buggy as well, with frequent crashes.	unlimited
Copy/Paste	Advanced. See documentation for details.	Limited. For instance, can not copy/cut columns. Views can be copied but not cut.	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	Advanced. See documentation for details.	Even more limited then ERwin. Beside all ERwin limitations, it cannot even re-order columns on the diagram or model explorer.	Limited. For instance, it doesn't have things like copy a column to an index/key and a new index/member member is created, copy a Tablespace to a table, etc…
Find	Find by name or any other property.	Limited. Only Table/View name.	Yes. Also, it has Replace.
Transaction Summary/Impact Analysis
ActiveX/Scripting		Limited. As Macros. It can not be run from within the application and it is not "generic".	Limited.  It can not be run from within the application and it is not "generic".
XML export
User Interface
Model Explorer
Modeless dialogs
Hyperlinked navigation
On-Diagram Editing	extensive (online demo)		Limited to Name editing.
Barker Notation (Oracle)
IE notation
IDEF1X notation
Auto-Layout
Object-level SQL preview.
Auto-Hide Toolbars
Diagram Themes
Modeling
Logical Modeling
Domains	nearly every type of object	limited to columns.	limited to columns.
Compare with Model		Actions are not executed in real time though. One needs to exit the dialog for the actions to be applied.
Naming options		limited. Only the length of the table is checked.
Model Subsets		limited. It supports submodel that don't allow multiple views per subset.
Key Migration	advanced: key-based or user-defined.	limited - no User-defined migration and no referential constraints on Views.	limited - no User-defined migration and no referential constraints on Views.
Unification
Rolenaming
User Defined Properties
Model Validation
Incomplete Objects
Versions support		Not in the stand alone version. Yes when used with ERStudio Repository.	Not in standalone. Yes, when using Model Mart.
Database
Multiple database support	limited to Oracle and MySQL.
Customizable Forward Engineering			using a proprietary script language.
Reverse Engineering	advanced with multiple filters.		it doesn't reverse engineer tables based on types.
Database Compare/Alter script	(fully  customizable)	but not customizable	but not customizable
Oracle Object-Relational support
Views & Materialized Views Management		Limited, but it does a better job than ERwin. Forcing a re-parse of the View DDL re-synchs the expressions with the name changes in the underlying tables/views.	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		Limited. SQL expression are not kept in sync with name changes in the base table.	Limited. However, as with any other SQL expression, they are not kept in synch with name changes in the base table.
Bitmap Indexes
Partitions
Advanced Oracle Physical Properties
Synonyms
SQL Expressions management (expressions in indexes, constraints, etc) are kept up to date with their referenced objects		Limited. It doesn’t work for function based indexes, for instance. It kind of works for views. The expression are not kept up to date, unless the DDL is manually parsed (by going to the DDL page).
Sequences
Syntax-colored SQL editor with built-in SQL execution		It has syntax-colored, but no SQL execution.	No syntax-colored, but it can execute SQL.
Price	$495	$4,370	$3,995 without Model Mart.