MicroOLAP Database Designer for MySQL

MicroOLAP Database Designer for MySQL Screenshot
  • Rating:
  • Version: 1.9.10 Build 555
  • Publisher: microolap.com
  • File Size: 7.17 MB
  • Date: Dec 24, 2009
  • Price: $124.95
  • License: Free Trial Software
    Free Trial 30 Days
  • Category:
MicroOLAP Database Designer for MySQL Download
Free Download MicroOLAP Database Designer for MySQL 1.9.10 Build 555

MicroOLAP Database Designer for MySQL is a visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and strong 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.
MicroOLAP Database Designer for MySQL allows you to construct your database in easy-to-understand visual environment by working with graphical representation of tables, columns, relations and so on.
Finally you will get Physical Entity Relationship Model (ER Model) that 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.
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 generate reports with complete information about a developed model/diagram in printer-friendly HTML view.

Diving into Database Designer for MySQL:
Draw the Database:
Place objects that would be in your database on a diagram, a virtual sheet of paper. See and realize the structure of your database and its objects: tables, views, stored procedures, functions and relationships between them. Construct tables, indexes, columns.
You can make use of already existing databases by reverse engineering them.
Easy Database Creation and Maintenance
With database designer you can quickly create a ready-to-use MySQL database with a few clicks, and then keeping its structure up-to-date by synchronizing it with the changes you made to visual diagram. Simply change the diagram - Designer will generate complex SQL statement for database modification that keep data safe for you. Moreover, you can synchronize several databases to the state of your diagram.
Documentation: Printing, Generating Graphics and Reports
Generate strong reports that describe all the database objects within 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.

MicroOLAP Database Designer for MySQL allows to construct your database in easy-to-understand visual environment by working with graphical representation of tables, columns, relations and so on.

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.

Finally you will get Physical Entity Relationship Model (ER Model) that 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.

Key Features:
All modern MySQL versions are supported (3.x, 4.x, 5.x, 6.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;

The license of this software is Free Trial Software, the price is $124.95, you can free download and get a free trial.

Database Management Software Related Downloads: