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.


What's New in This Release:

· Full support for databases MS SQL Server 2005 and Sybase ASE 15,
· new way of HTML reports generation and more.