ADVERTISEMENTS

MicroOLAP Database Designer for MySQL is a product specially developed for MySQL database. It allows you to build a clear and effective database structure visually, by working with the complete picture (diagram) representing all the tables, references between them, views, stored procedures within your database. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram.

This product allows to extract tables, attributes, relationships, indexes and other objects from existing databases including MySQL, Microsoft Access and Sybase ASE/ASA, Oracle, Informix, MSSQL, DB2, DBF and many others that accessible through OLEDB or ODBC and import (reverse engineer) them into your diagram.

You can additionaly export graphical representation of diagram to EMF, JPEG, PNG, GIF and other popular formats or print the diagram out on multiple pages. Physical Entity Relationship Model (ER Model) can be exported in SQL script, or directly built on working MySQL database server. After your database model/diagram is modified, you can synchronize existing MySQL database with it.

Features of Database Designer for MySQL:

• All modern MySQL versions are supported (3.x, 4.x, 5.x)
• Support for views, stored procedures, functions and triggers
• Support for logical domains
• A direct connection to MySQL: any intermediates are not required (ODBC, ADO/OLEDB, etc.)
• Reverse engineering of MySQL databases
• Reverse engineering of multiple data sources through ADO/OLEDB
• Multi-document interface
• SQL scripts editing and executing
• Ability to check diagram correctness
• Easy diagram objects location and modification
• Full customization of diagram and objects appearance
• Fast, easy graphics manipulation
• Diagram reporting
• Exporting diagram to various graphical formats (PNG, JPEG, GIF, BMP, and EMF)
• Database synchronization by SQL script
• Entity Relationship Diagram (ERD) editor
• Database generation
• Database Connections Manager
• Object browser for entities, relationships, attributes and domains

Synchronize Database tool can generate a new database and synchronize an existing MySQL database with the model you are developing. MicroOLAP Database Designer will generate all required SQL statements to reduce the complexity and improve the reliability of all database modification tasks in two clicks.

The price of Database Designer for MySQL starts from $124.95, a bit too expensive. You can download the full feature evaluation to try before purchase from: http://www.microolap.com/products/database/mysql-designer/download/