Database structure modeling, generation and modification focused on PostgreSQL
Questo prodotto non è più disponibile
The MicroOLAP Database Designer for PostgreSQL is an comprehensive CASE tool with intuitive graphical interface allowing you to
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 a few clicks, and then keeping its structure up-to-date by synchronizing it with the changes you made to a visual diagram. Simply change the diagram — Designer will generate complex SQL statement for database modification to bring it to the state of diagram keeping data in 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 graphical representation of diagram to EMF, JPEG, PNG, GIF and other popular formats or print the diagram out on multiple pages.
Database Designer for PostgreSQL makes the process of database creation clear and simplifies maintenance of the databases. All the operations performed in a fast, handy and intuitive interface.
The product designed for popular PostgreSQL database server and takes into account all its features including:
The product can extract tables, attributes, relationships, indexes and other objects from existing databases including PostgreSQL, Microsoft Access, MySQL, 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.
In the end, you'll get a Physical Entity Relationship Model (ER Model) that can be exported in SQL script, or directly executed on working PostgreSQL database server. After making changes to a diagram, you can synchronize existing PostgreSQL database with it by using Database Modification tool.