Toad Data Modeler - Features Matrix

(1)

Toad Data Modeler - Features Matrix

Functionality Commercial Trial Freeware Notes

General Features Physical Model (database specific)

Saving model is limited to 25 entities.

Universal Model (generic physical model)

Logical Model

(support for inheritance)

Key Features (based on Physical Model) Visual modeling (entities/tables, relationships, views)

Database specific items creation and management (procedures, triggers, functions, sequences…)

List of object types depends on selected target database.

Model Verification Shows errors, warnings and hints.

Ordering of objects for SQL code generation

Generate stored procedures before functions etc.

Generation of SQL/DDL Scripts Generation of SQL/DDL script is

limited to first 25 entities. Reverse Engineering from Physically

Existing Database

Reversing database schema is limited to 25 entities. Other objects have no limitation.

Reverse Engineering from SQL script

Selected database platforms only. Same limitation as RE from database.

Live RE

Connect to DB and use drag and drop technique to add objects from DB to model. Limited functionality. HTML Report Generation

Trial contains 25 entities limit and freeware doesn’t contain this feature at all.

RTF Report Generation

PDF Report Generation

PDF reports with watermarks are limited to a maximum of 25 entities. Number of reported other objects is not limited.

Comparison (alter) reports Generating alter reports is limited to

25 entities.

XSL Transformation reports Limited to first 25 entities. Other

(2)

Synchronization and Conversion

Model Conversion Convert Oracle 11g R2 to model for

MS SQL Server 2008

Model Compare Find differences and generate

report. Model Merge

Model Update

Physical from database

Reversing database schema is limited to 25 entities. Other objects have no limitation.

Model Update

Logical from Physical

Logical model cannot be updated due to multiple rules for inheritance conversion.

Generation of Alter Scripts (change scripts)

Other Useful Productivity Oriented Features Projects

Internal Version Manager Support for Subversion Naming Conventions

Gallery for storing frequently used parts of models.

Refactoring Utility

Selected DB only. Change SQL code of stored procedures, views…where renamed object is detected. Automatic FK mapping

Categories

To-Do Items Management

Auto-layout Default and Alphabetic.

Undo/Redo Limited to one step.

Multiple Workspaces Default Values

SQL Preview (table, index, relationship, procedure etc.)

Full Unicode Support Diagram Export and Print

Preview Preview is limited to 25 entities.

Print Printing is limited to 25 entities.

Export to Graphic File Export to graphic file is limited to 25

(3)

GUI

Advanced Align Palette Currently in BETA version. Objects

alignment and objects resize. Loupe (magnifier glass)

Overview (navigator) Zoom

Log Pane and Message Explorer Copy and Move Attributes in ERD

Linked attributes highlighting See linked attributes visually.

In-Place Editing Change object names directly in

diagram! Changeable Notation (Crows feed,

IDEF1X)

Modeless Dialogs

Edit entity, edit stored procedure, edit trigger…

at the same time. Detailed Formatting Options for Objects

Multiple Graphical Representation of One Object on Workspace

Grid With Snap to Grid.

Comments Displayed as Hints Support for two Monitors

Drag and Drop From one model to another.

Customization - Meta Model and Extensibility

Easily Scriptable Objects Use Java Script to make batch

operations.

Scripting Window Run Java Script code from Scripting

Window.

Extensible Objects Add properties to existing objects

and store values with your model.

Customization of Forms Add tabs, fields, combo boxes… to

existing forms.

Macros and Custom Packages Extensions, custom features and

more. Import of Macros and Custom Packages

Script Explorer Package Explorer

(4)

Logical ER Diagram

Inheritance Cardinality

Logical Data Types (business terms) No autoincrements etc.

Ability to select Data Type mapping from Logical to Physical

Graphical Display of Mandatory and Optional Items

Multiple Logical Notations

Migration of key attributes to child entities

Both Logical and Physical Names Notations for Inclusive and Exclusive Inheritance, Super and Subtypes, Complete and Incomplete Universal ER Diagram Inheritance

Cardinality

Generic Data Types

Migration of key attributes to child entities

Both Logical and Physical Names Physical ER Diagram

Inheritance Cardinality

Database specific Data Types Migration of key attributes to child entities

Both Logical and Physical Names Not Null synchronization Definition of Default data type Domains Management Dictionary Items Management Export/Import of Dictionary Items Support for Compound Foreign Keys Support for Partitioning

Database specific items Materialized views, sequences,

(5)

Compatibility / Integration

Import of Toad for Oracle projects Support for Toad for Oracle ER Diagrams Recognition of Toad for Oracle aliases Toad as Default Editor for generated SQL scripts

Toad for Oracle icon theme Older Versions Compatibility

Import of Toad Data Modeler 2 and CASE Studio 2 binary files

Import of XML files created in Toad Data Modeler 2 or CASE Studio 2

Expiration

Expires - 15 days after

installation Fixed date

Visit modeling.inside.quest.com for more information about BETA version expiration.

Legend:

- Functionality is not limited. - Functionality is limited. - Functionality is not available.

Trial Version Limitations:

If you want to trial Toad Data modeler without limitations, please contact your Quest Sales Representative at sales@quest.com to request a full functionality trial override key.

The main difference between Trial and Freeware version is that with Trial version you can  reverse engineer large database structures

 generate HTML or RTF report (limited to 25 entities)

 generate Alter Script for your modifications (limited to 25 entities) List of supported database platforms

Toad Data Modeler supports Oracle Database, Microsoft SQL Server, MySQL, PostgreSQL, MS Access, Sybase ASE, Sybase IQ, Teradata, SQLite and other database platforms.