CASE Studio 2 - create ER diagrams for various databases, generate SQL scripts, HTML reports... CASE Studio 2 is a professional and intuitive database design tool, which allows you to visually create Entity Relationship diagrams (ERD) for various database systems.
It includes a full support of the following databases: Oracle, DB2, MS SQL, InterBase, MaxDB, MySQL, PostgreSQL, Sybase ASE, MS Access, Firebird, Advantage Database Server, Ingres, Informix, Pervasive V8, DBISAM and several others.
When creating ERD the program considers individual database options such as referential integrity, constraints, domains, triggers, user permissions etc. CASE Studio 2 provides a gallery for saving and storing most frequently used parts of models or a dictionary with predefined user data types.
Moreover, data flows between tables can also be easily described by creating appropriate Data Flow Diagrams (DFD).
Here are some key features of "CASE Studio":
Full support for Informix 10
Possibility to create Entity relationship diagrams
Automatic SQL script generation
Reverse engineering of existing database structures
Full support of the Informix 10 specifics
Possibility to select an own terminator
and many more...
Full support for Pervasive v9
Possibility to create Entity relationship diagrams
Automatic SQL script generation
Reverse engineering of existing database structures
Full support of the Pervasive v9 specifics
User-defined Functions fully supported (SQL generation and also reverse engineering)
and more...
Completely updated support for IBM DB2 UDB v 8 (more than 40 changes and enhancements)
Full support for IBM DB2 UDB version v 8.2
Changes in support of older versions IBM DB2 UDB
Reverse engineering feature enhanced
New text objects supported (aliases, triggers for views etc.)
and more...
Full support for Sybase ASE 12.5.3
The templates version 12.5.3 include support for Sybase 12.5.1, 12.5.2 and 12.5.3.
To be able to work with Sybase ASE 12.5, it will be necessary to use other templates.
Templates Editor
System templates can be easily copied. To create a user-defined template based on a system template, just right click on the selected system template and choose an option for copying the content. All parameters of the system template together with the content will be set up automatically.
HTML reports
New design of HTML reports. Identical report view in browsers MSIE and Firefox, corrections of HTML code and structure of CSS files. Special CSS file for printing of HTML reports.
Possibility to generate images of large ER diagrams. (The size of ER diagram image is checked. When the size of 30.000.000 pixels is exceeded, a notification whether to generate such large image or not will appear.)
Corrections to the User Permission HTML Report: a user has been added to roles, a content instead of YES in the "users with role permissions" section, new checkbox "More detailed report of users with role permissions", new tab where all objects and their permissions (Object with permissions) are written out and new checkbox "Generate all objects with their user and role permissions" have been added.
CASE Studio
CASE Studio LITE
Foxy SQL Pro
Web developer s help