MicroOLAP Database Designer 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 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. You can get it for PostgreSQL and MySQL.

What’s new:

[*] CHECK constraints expression Reverse improved a lot

[*] Model tags are treated case-insensitive now

[*] Disallow modification of columns and constraints referenced by Foreign Key

[+] Smart reference counter added to avoid name duplicates

[+] Ability to choose default folder for model files added

[+] SQL Reverse Engineering for CREATE statements added

[+] “Open last edited files at startup” feature added

[+] Interval backup/autosave

[+] “Leave current tool” options added

[+] “Quick hand tool” feature added

[+] Ability to select references or tables connected to selected table (Popup menu item)

[+] Enhanced reference visualization for selected tables added

[-] “Modify Database is trying to ALTER TYPE for timestamps with the same parameters” bug fixed

[-] “Modify Database is trying to DROP DEFAULT on SERIAL columns on PostgreSQL 8.2.x” bug fixed

[-] “Duplicate operation in Table Editor duplicates column and constraint ID” bug fixed

[-] “Table object context menues “SQL Preview” & “Format” open wrong Table Editor tabs” bug fixed

[-] “Error while reverse scalar types: index out of range(4)” bug fixed

[-] “Storage properties were fetched incorrectly” bug fixed

[-] “Impossible to define SETOF return of the SP in Stored Routine Editor” bug fixed

[-] “Copy/Paste is unavailable in rule actions memo of View Editor” bug fixed

[-] Problems with references numeration

[-] Bug with object search by partial string

[-] Scale Combobox is not updated on Actual Size (F5)

Check it out.