Category: Main Productivity Database Database Designer 1.2.7 for PostgreSQL

Database Designer

[!] Table dependent composite type can be used now

[+] "Use SQL standard type names instead of specific PostgreSQL" option added

[+] ALTER TABLE ... ADD CONSTRAINT supported in SQL Script Reverse Engineer now

[+] AutoInc option is set for columns with SERIAL and BIGSERIAL types while SQL Script Reverse Engineer

[+] Comment support for constraints, indices, triggers and rules added

[+] Fill Factor and Tablespace support added for UNIQUE and PRIMARY KEY constraints

[*] Added checking to exclude return type "trigger" for stored routine in SQL language

[*] Object creation order can be changed in Generate Database now

[*] Repair Model improved for stored routines

[*] Scale of underlying numeric type of domain is reversed now

[-] "CREATE TABLESPACE cannot be executed from a function or multi-command string" error fixed

[-] "EAccessViolation error occured while Reverse Engineer table field with user defined type" bug fixed

[-] "EZeroDivide: Floating point division by zero" bug fixed

[-] "Impossible to select "xml" and "bit varying[]" types" bug fixed

[-] "Index Manager doesn't allow edit attributes" bug fixed

[-] "Invalid Type Cast error while Reverse Engineer SQL Script with table constraints" bug fixed

[-] "Schemas have invalid object identifiers after Reverse Engineer SQL Script" bug fixed

[-] "Sometimes objects have smaller width then needed after zooming" bug fixed

[-] "SQL Script Reverse Engineer failed for numeric precision and scale" bug fixed

[-] "SQL Script Reverse Engineer incorrectly parses dollar-quoted stored routine definition" bug fixed

[-] "SQL Script Reverse Engineer incorrectly parses single-quoted stored routine definition" bug fixed

Application Details:

Version: 1.2.7 for PostgreSQL
License: Shareware
Votes: 0
Latest Rating: Gold
Latest Wine Version Tested: 1.1.19

Maintainers: About Maintainership

No maintainers. Volunteer today!

Test Results

Old test results
The test results you have selected are very old and may not represent the current state of Wine.
Selected Test Results

What works

All the stated by developers functionality works

What does not


What was not tested

Reverse Engineer from Ms Access database

Hardware tested


  • GPU:
  • Driver:

Additional Comments

This application needs at least MS MDAC 2.5: Microsoft ODBC drivers, etc. To install them use winetricks:

selected in Test Results table below
Operating systemTest dateWine versionInstalls?Runs?Used
ShowUbuntu 8.10 "Intrepid" i386 (+ variants like Kubuntu)Apr 15 20091.1.19Yes Yes Goldan anonymous user 
ShowSlackware 12.2Mar 26 20091.1.17Yes Yes Goldan anonymous user 
CurrentUbuntu 8.10 "Intrepid" i386 (+ variants like Kubuntu)Jan 16 20091.1.12Yes Yes SilverPavel Golub 

Known Bugs

Bug # Description Status Resolution Other apps affected

Show all bugs

HowTo / Notes

“Database Designer under Wine” HOWTO


“When’s the Linux version coming out?” - David Fetter was asking me.

“I can’t answer this question yet” - was the answer.

But the magic happens. :) I succeeded to launch Database Designer for PostgreSQL in Wine. The instructions below will help you start Database Designer for MySQL either.


All my tests were made using:

  • Ubuntu 8.10 “Inteprid”
  • Wine 1.0.1 (stable) and 1.1.13 (development)
  • Winetricks version 20090117

Despite the fact that Wine 1.1.13 marked as development version I strongly suggest you to use exactly this release. Because in 1.0.1 there are a lot of visual artefacts, however functionality is stable.

Configure Wine

Since Database Designer for PostgreSQL uses Microsoft Data Access Components for its Universal and MS Access Database Reverse Engineering we must install appropriate redistributable runtime libraries:

$sh winetricks jet40 mdac28

jet40 - MS Jet 4.0 Service Pack 8
mdac28 - MS MDAC 2.8: Microsoft ODBC drivers, etc.

After this we already can use application with its full functionality. However, fonts used in Designer appear ridged. To fix this we need to install Microsoft Core Fonts (Arial, Courier, Times etc.), but we need to make sure  cabextract utility is present in our system.

In case of Ubuntu we can use the following command to install it:

$sudo apt-get install cabextract

For other distributions it is better to check manuals. To install core fonts we run:

$sh winetricks corefonts

Wine Application Database

In Wine Application Database you can get information on application compatibility with Wine. There are entries for both Database Designers: for PostgreSQL and MySQL.

By the way, you have a good chance to get a free Personal License. Provide some great examples of using Database Designers and results you got under Wine, and receive a license key for free! If you publish them as an article (in your blog, for example), this is only a big plus. Requirements: created with MicroOLAP software, step by step description (How did you make it?), screenshots of the steps taken.

Write a review of MicroOLAP software and publish it on Wine Application Database web-site. You will get a free Personal License key as a reward.

Our goal is to make Database Designers Platinum list member of Wine Application Database. As for now it appears to be Gold List member.


Comments Disabled

Comments for this application have been disabled because there are no maintainers.