Monday, July 23, 2007

MicroOLAP Database Designer for PostgreSQL ver.1.2.1released

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.