This software provides a visual development system for easy and powerful database design, modeling, creation, modification, and reverse engineering. It simplifies MySQL database maintenance and accelerates the process of database creation, making it clear and concise.
MicroOLAP Database Designer for MySQL is a powerful development system aimed at simplifying database design, creation, modeling, modification and reverse engineering. The software not only speeds up the process of database creation but also streamlines maintenance tasks.
Specifically developed for the popular MySQL database, MicroOLAP Database Designer for MySQL takes into account the various features of MySQL tables, such as InnoDB, BDB (Berkeley DB), MyISAM, ISAM, MySQL references and all MySQL field types (including MySQL ENUM and SET fields). The software supports ANSI-92/ANSI-99 and MySQL SQL syntax extensions, making it easier to work with databases.
One of the key benefits of the database designer is its easy-to-understand visual environment, which allows users to work with graphical representations of tables, columns, relations, and other database objects. Using this feature, users can create a Physical Entity Relationship Model (ER Model), which can be exported in SQL script or directly built on a working MySQL database server.
MicroOLAP Database Designer for MySQL also includes the ability to synchronize an existing MySQL database with a modified database model or diagram. Additionally, the software allows users to extract tables, attributes, relationships, indexes, and other objects from existing databases including MySQL, Microsoft Access, Sybase ASE/ASA, Oracle, Informix, MSSQL, DB2, DBF and many others that are accessible through OLEDB or ODBC.
Finally, the software also makes it possible to generate reports with complete information about a developed model/diagram in printer-friendly HTML view, adding to its already robust set of features. With its user-friendly interface and extensive functionality, MicroOLAP Database Designer for MySQL is a must-have tool for anyone dealing with MySQL databases.
Specifically developed for the popular MySQL database, MicroOLAP Database Designer for MySQL takes into account the various features of MySQL tables, such as InnoDB, BDB (Berkeley DB), MyISAM, ISAM, MySQL references and all MySQL field types (including MySQL ENUM and SET fields). The software supports ANSI-92/ANSI-99 and MySQL SQL syntax extensions, making it easier to work with databases.
One of the key benefits of the database designer is its easy-to-understand visual environment, which allows users to work with graphical representations of tables, columns, relations, and other database objects. Using this feature, users can create a Physical Entity Relationship Model (ER Model), which can be exported in SQL script or directly built on a working MySQL database server.
MicroOLAP Database Designer for MySQL also includes the ability to synchronize an existing MySQL database with a modified database model or diagram. Additionally, the software allows users to extract tables, attributes, relationships, indexes, and other objects from existing databases including MySQL, Microsoft Access, Sybase ASE/ASA, Oracle, Informix, MSSQL, DB2, DBF and many others that are accessible through OLEDB or ODBC.
Finally, the software also makes it possible to generate reports with complete information about a developed model/diagram in printer-friendly HTML view, adding to its already robust set of features. With its user-friendly interface and extensive functionality, MicroOLAP Database Designer for MySQL is a must-have tool for anyone dealing with MySQL databases.
What's New
Version 2.1.9: This is maintenance release focused on tuning bug reports facility. It also improves user experience allowing hide unneeded objects. Fixes some nasty bugs.