MicroOLAP Database Designer for PostgreSQL 18.104.22.1682 | 13.36 MB
is an easy CASE tool with 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 ******s. 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 Designer
makes the process of Database
creation clear and simplifies maintenance of the databases. All the operations performed in a fast, handy and intuitive interface.
Place ******s of your Database
on a diagram, a virtual sheet of paper. See and realize the structure of your Database
and its ******s: 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.
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.
********ation: Printing, Generating Graphics and Reports
Generate powerful reports that describe all the Database
******s 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.
The product can extract tables, attributes, relationships, indexes and other ******s 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 ******, 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
• Simple physical Database
creation by using a wizard;
modification: generation of ALTER statements to bring a Database
to the state of the diagram;
• Reverse engineering (import) of existing databases from multiple sources;
• Export of a diagram to popular graphics formats;
structure reports generation;
• Cheking a diagram for errors;
• Merging of diagrams;
• Ability to print diagram out on multiple pages;
• Works under Windows 2000, XP, 2003.
• Support of PostgreSQL
server starting from 7.4 and a partial support of PostgreSQL
Home Page - http://mayfotaksh.com/37918