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).
Key features also include: universal reverse engineering, which allows you to reverse engineer already existing database structures; version manager; creation of very detailed HTML and RTF reports; SQL/DDL scripts generation; ER-diagrams comparison; conversion of ER diagrams into other databases; pattern editor for triggers, views and stored procedures; support of JScript and VBScript, export of diagrams into graphic files and many more.