Version differences

CASE Studio 2 - Feature	LITE	FULL
Entity relationship diagrams
Clipper (older version)
DBISAM 3
IBM DB2 UDB ver. 8.1
IBM DB2 UDB ver. 7.1
Informix (older version)
Informix 9
Ingres (older version)
InterBase 7
InterBase 6 SQL 3
InterBase 6 SQL 1
InterBase 5
InterBase 4
MS Access 2000
MS Access 97
MS SQL 2000
MS SQL 7
MS SQL 6.5
MySQL 4 (incl. innoDB)
MySQL 3.23
Oracle 9
Oracle 8
Oracle 7
Paradox (older version)
Pervasive
PostgreSQL 7.3 BETA
PostgreSQL 7
Sybase 12.5

Data flow diagram
Data flows
Data stores
Processes
Terminators

Reverse engineering
Clipper (older version)
DBISAM 3
IBM DB2 UDB ver. 7
IBM DB2 UDB ver. 8
Informix (older version)
Informix 9
Ingres (older version)
InterBase 7
InterBase 6 SQL 3, InterBase 6 SQL 1
InterBase 5
InterBase 4
MS Access 2000
MS Access 97
MS SQL 2000
MS SQL 7
MS SQL 6.5
MySQL 4 (incl. innoDB)
MySQL 3.23
Oracle 9
Oracle 8
Oracle 7
Paradox (older version)
Pervasive
PostgreSQL 7.3 BETA
PostgreSQL 7
Sybase 12.5

Reports & export possibilities
RTF reports
HTML reports
Export into JPG, BMP or PNG
Export into XML

Features
After script items
Alternate keys
Alter scripts
Autolayout
Before script items
Cardinality
Data dictionary (domains)
Descriptions
Drops generation
Foreign keys definition
Functions
Indexes
Informative relationships
Internal clipboard
M:N relationships
Network features
New user defined data types
Non-identifying relationships
Notes
Object type bodies*
Object types*
Package bodies*
Packages*
Patterns for views, procedures and triggers
Primary keys definition
Referential integrity
Rough uppercase/lowercase selection
Self relationships
Sequences*
SQL script generation
Storages
Stored procedures
Support of compound foreign keys
Synonyms*
Triggers
User permissions (in models)
Users (in models)
Users group (in models)
Views

Model maintenance
Database/Model conversion**
Gallery
Model check
Submodels
To-Do list
Version comparsion
Version manager

Scripting and user defined templates
OLE Automation objects
Large COM interface
MS Scripting
Jscript support
VB script support
Templates editor
Templates export
Templates import
User defined variables editor

Displaying
Visual creation of DFD
Visual creation of ERD
Alignment in columns
Attributes syntax highlighting
Entity background color selection
Font selection
Logical model
Physical model
Logical view / physical view
Model background color selection
Shadows
Stamp
Straight relationship lines
Text descriptions
Variable display level

Support
Free email support
Free updates of CASE Studio 2

Tip

Press F11 to open the internal Gallery

What Do They Say ?

I have found CASE Studio 2 to be an outstanding tool. I looked long and hard for a CASE tool that would suit medium size projects, as I did not require an enterprise solution and an enterprise price tag. Other products had limited functionality, and did not provide reverse engineering support, in-depth reports or the ability to save different versions of the model. Not only does CASE Studio 2 support this, you can extend the reporting and generation functionality using the template facilities. The interface is crisp, and the application is a joy to use. I wholeheartedly recommend it.

Dan Horne
IT professional

ERD

DFD

Reverse engineering

HTML reports

Version manager

Script generation

For further information contact enquiries@advantages.co.nz