Navicat on Linux

I love using Navicat for MySQL. I've tried a lot of different UIs for MySQL administration and this one is worth the price.

And I applaud PremiumSoft for having a Linux version. Unfortunately, the Linux version is really the Windows version with an included version of Wine, tweaked to run Navicat. Seems kind of strange to have 2 versions of Wine on my system.

So I purchased a copy of the Windows version and set to work figuring out how to get all the features to work and how to make it look like a native app as well.

In order to do things like saving data transfer profiles, you'll need to do the following.

1. Use Google to find download links to Pgmr101.ocx, msxml3.dll and msxml3r.dll or get them from a Windows XP distribution. Copy these to Wine's system32 directory, overwrite as required (but backup any existing files just in case). In my case, I copied them to /home/omerk/.wine/drive_c/windows/system32/

2. Run a DOS (yes DOS) terminal:
env WINEPREFIX="/home/{your_home_dir}/.wine" wine "C:\windows\system32\cmd.exe"

3. Paste these DOS commands and hit enter for each:
regsvr32 msxml3.dll
regsvr32 /s msxml3.dll
regsvr32 msxml3r.dll
regsvr32 /s msxml3r.dll
regsvr32 Pgmr101.ocx
regsvr32 /s Pgmr101.ocx

You may need to cd into the system32 directory for this to work.

4. In Ubuntu, open Applications > Wine > Configure Wine.

5. In Libraries > Existing Overrides:
msxml3.dll(native, builtin)
Note that the order is important: native, then builtin.

6. Install the Windows version of Navicat via Wine and you should be good to go.

In terms of fonts, they can be tweaked either at the Wine level or in the application itself. Note that if you change fonts in the application, you must re-start it to see the changes.

Mine looks like this...