MicroOLAP Database Designer for PostgreSQL

MicroOLAP Database Designer for PostgreSQL is a complex, but intuitive piece of software, meant to help you build database structures in diagram form. You can then generate a physical database or export created models to various image formats.

It goes without saying that building a database can be an arduous task. However, this process is greatly simplified when you have access to a diagram that displays all database objects in an easily accessible form.

MicroOLAP Database Designer for PostgreSQL allows you to view and easily manipulate tables, attributes, indexes, schemas, domains and other objects.

It is possible to merge selected content from two separate diagrams, check them for common errors and repair them, should their underlying structure be damaged.

Once you have finished designing a database structure, you can have the application generate an SQL script and execute it on the database server. This operation is simplified by the built-in wizard mode. All you need to do is follow a few simple steps, customize various SQL generation settings and choose which objects should be included.

The application also offers a useful Reverse Engineering function, allowing you to extract tables, attributes, indexes and other objects from existing databases.

MicroOLAP Database Designer for PostgreSQL allows you to export the created diagram to EMF, PNG, GIF, JPG or BMP files. The application can automatically create a separate image for each page in your model.

It is possible to generate a comprehensive HTML report that describers all the objects in your model, with links to the various sub-sections. It can also include a picture of the diagram, for visual reference.

This is a powerful application that can help you visually design PostgreSQL databases. It offers a large amount of useful functions and features an intuitive interface.