CASE Studio 2 is a professional and intuitive database designing 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, MySQL, PostgreSQL, Sybase ASE, MS Access, Ingres, Informix 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 structure; version manager; creation of very detailed HTML and RTF reports; generating of SQL scripts; comparing ER-diagrams; conversion of ER diagram 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.
Keywords: CASE ER diagram case studio casestudio database model design DDL SQL script data flow reverse engineering RE oracle DB2 interbase sybase mysql mssql access DF ERD IDEF1X support software tool utility |
