Introduction

Welcome to MicroOLAP Database Designer for MySQL

MicroOLAP Database Designer for MySQL is an innovative development system intended for visual 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 MySQL database and takes into account its features. The new features of MySQL 5.0 such as stored procedures, functions and views are fully supported.

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 modification of model you can synchronize existing MySQL database with it.

The 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.

You can generate reports with complete information about a developed model in printer-friendly HTML view.

Please note, that there are plans to release versions of the product that will support other popular databases.

Getting Started

The fastest way to start using the product and find out more about it is to become familiar with:

Creating Your First Diagram tutorial
Short overview of Main Window Organization

Workspace: Main Window Organization

Diagram: Creating a New Diagram