“Database Designer for PostgreSQL under Wine” HOWTO

MicroOLAP Database Designer for PostgreSQL 1 Minute

Preface

“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.

Platform

All my tests were made using:

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.

Published by pashagolub

Nerd.

Published

11 thoughts on ““Database Designer for PostgreSQL under Wine” HOWTO”

  1. Hey man!

    What if I do not want to install Microsoft Direct Access Components? Will it still work, any restrictions maybe?

    Thanks for the tutorial, BTW!

    Like

    Reply

  3. Kewl!

    Reverse Engineering is a nice feature, though I don’t use it much. So, it works for me.

    When 1.2.8 version will be released?

    Thanks!

    Like

    Reply

    1. Thanks! Free license is not a problem!
      Just post information to WinHQ Application Database about your experience on running application in Wine. You should describe the environment application was ran at and how successfully you did it.

      That is all. After that I’ll give you a personal license for free.

      To proceed you should register here. Then you’ll need to go to Designer’s Page where to choose link “1.2.7 for PostgreSQL” in Version column and click “Add Test Data” button finally.

      Like

      Reply

Leave a comment