MicroOLAP Database Designer for MySQL is a visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and powerful way.It not only accelerates and makes the process of database creation clear, but also simplifies database maintenance.MicroOLAP Database Designer for MySQL is specially developed for popular MySQL database and takes into account its features:Various MySQL tables types: InnoDB, BDB (Berkeley DB), MyISAM, ISAM... MySQL references (InnoDB tables only: only this MySQL table type supports references); all MySQL field types (including MySQL ENUM and SET fields). Certainly, MicroOLAP Database Designer for MySQL supports ANSI-92/ANSI-99 and MySQL SQL syntax extensions (ANSI-2003).Features spotlight:Multi-document interface; Support of all modern MySQL versions (3..x, 4.x, 5.x);Domains support. Usage of domains is supported even for a database that does not support domains at all;Direct connection to MySQL: any intermediate connection level as ODBC, ADO/OLEDB, etc. are not required; Easy diagram objects location and modification; Ability to check diagram correctness; Reverse-engineering of multiple data sources through ADO/OLEDB; Diagram reporting; SQL scripts editing and executing;Full customization of diagram and objects appearance;Exporting diagram to various graphical formats (PNG, JPEG, GIF, BMP, and EMF); Database generation; Database synchronization by SQL script; Database Connections Manager; Entity Relationship Diagram (ERD) editor; Fast, facile graphics manipulation; Abilities to establish connection using SSH tunneling and secure SSL channel;Powerful tool for test data generation;Object browser for entities, relationships, attributes and domains. |