Free download microOLAP Database Designer for PostgreSQL

microOLAP Database Designer for PostgreSQL

An easy and powerful visual development system intended for database design, modeling, creation
Free Download
User rating
11 votes
File size
20.3 MB
Release date
24 June 2009

Publisher's description

Database Designer for PostgreSQL is an easy CASE tool with an intuitive graphical interface allowing you to build a clear and effective database structure visually. See the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.
Database Representation:
Place objects of 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 schemas, domains, tables, indexes, columns and triggers.
You can import already existing databases to a diagram by reverse engineering.
Easy Database Generation and Maintenance:
With the database designer, you can quickly create a ready-to-use PostgreSQL database with just a few clicks, and then keep its structure up-to-date by synchronizing it with the changes you made to a visual diagram. Simply change the diagram, and the Designer will generate the complex SQL statement for database modification to bring it to the state of the diagram, keeping the data safe. Moreover, you can synchronize several databases to the state of your diagram.
Documentation: Printing, Generating Graphics and Reports:
Generate powerful reports that describe all the database objects within your diagram. You can export a graphical representation of the diagram to EMF, JPEG, PNG, GIF and other popular formats or print the diagram out on multiple pages.

User comments

David Hawkins
I`m new to the SQL world though i`ve had many years of experience with web and programming applications. I found this program to be ideal for those trying to familiarize themselves with how SQL works. You can draw out the tables and references on the screen, and then look at the code that is produced to assist in learning to code! A Definitely solid program if you are new to SQL.
Rate this program