The reverse engineering process will extract the database's entities, attributes,
relationships, indexes, triggers, procedures, and other objects depending on the particular
database. Not all of those features are supported by all databases. In addition to
being able to work with a number of databases, CASE Studio 2 is able to use a number
of different communication methods:
ODBC
ADO
BDE
direct native connections where appropriate.
How can it help me?
CASE Studio 2 allows you to generate very detailed HTML and RTF documentation. It
is a perfect tool for creating documentation of your already existing database structure.
You can redraw the db structure, insert the model into the internal Version Manager
or generate new SQL (DDL) scripts for a physical creation of new database.
During the reverse engineering process, CASE Studio 2 loads various objects of selected
databases. Each database has its own specifics and CASE Studio 2 respects them as
possible.
Supported databases
Database
Native
ODBC
ADO
BDE
Oracle 9x
-
-
Oracle 8x
-
-
Oracle 7x
-
-
DB2 version 8 UDB
-
DB2 version 7 UDB
-
DBISAM 3
-
-
-
MS SQL 2000
-
-
MS SQL 7
-
-
MS SQL 6.5
-
-
MS ACCESS 2000
DAO 3.6
-
-
-
MS ACCESS 97
DAO 3.5
-
-
-
InterBase 7
-
-
InterBase 7
-
-
InterBase 6 SQL 3
-
-
InterBase 6 SQL 1
-
-
Sybase Adaptive Server 12.5
-
-
MySQL 4
-
-
-
MySQL 3.23
-
-
-
PostgreSQL 7.3
-
-
PostgreSQL 7.1
-
-
Informix
-
-
-
-
Informix 9
-
-
Pervasive
-
-
Ingres
-
-
-
-
Clipper
-
-
-
-
Paradox
-
-
-
-
Tip
Double click an Entity name from the left Overview tree to edit the entity.
What Do They Say ?
The software is one of the most complete CASE packages that is available at a reasonable price, and the continuous attention to maintaining and adding functionality to the software is greatly appreciated..
Database design
draw the db structure, insert the model into the internal Version Manager
or generate new SQL (DDL) scripts for a physical creation of new database.
