Devart Blog

dbForge Studio for MySql on Linux family operating systems

Posted by on June 22nd, 2011

Despite the fact that dbForge products were developed only for Windows platforms, our active users (thanks to Tsvetkov) have found a way to use some features of dbForge Studio for MySql on Linux family operating systems.

Tests were run under .Net Framework 2.0 on Wine emulator.

The following command line functionality works with no visible issues:

  • /backup – backups a database
  • /restore – restores a database
  • /datacompare – launches a data comparison
  • /datacompare /sync – launches a database synchronization
  • /schemacompare – launches a schema comparison
  • /schemacompare /sync – launches a database synchronization
  • /dataexport (starting from version 5.0) – exports data
  • /dataimport (starting from version 5.0) – imports data
  • /execute – executes a script

Testing of the following GUI functionality completed with full success:

  • Import Wizard
  • Export Wizard
  • Backup Wizard
  • Restore Wizard
  • SQL Formatter Wizard

Data comparison. We were able to perform data comparison operation with some limitations:

  • there is no possibility to view differences between the records of the relevant objects
  • Data Synchronization Wizard doesn’t work at all

Schema comparison. Testing of the schema comparison functionality finished with the following results:

  • Schema Comparison Wizard works properly
  • Schema Synchronization Wizard is supported excepting the possibility to view synchronization script for the object. However, you can save documents and use them as a command line argument

Stored procedures debugger. Works properly if you disregard the artifacts.

The rest of the functionality is associated with tool-windows or documents and mostly blocked because of problems with rendering. To avoid the issues associated with tool-windows, change the window status from Docked to Floating and vice versa.

If you are interested in using dbForge Studio for MySql on Linux, you can use the following installation recommendations:

1. Build wine with the following options:

app-emulation/wine-1.3.3 USE="X alsa dbus gecko jpeg ncurses opengl perl png ssl threads
truetype win32 xinerama xml (-capi) -cups -custom-cflags (-esd) -fontconfig -gnutls
(-gphoto2) -gsm (-hal) -jack -lcms -ldap -mp3 -nas -openal -oss -pulseaudio -samba (-scanner)
 -test -win64 -xcomposite"

2. Install to a new folder .wine files (optionally, but preferably)

3. Run:

- sh winetricks gdiplus

Note: Do not use gdiplus from wine (dbforge crashes with an error when starting)

4. Install dotnet20 (in Fedora13 the installation interrupts with an error):

- sh winetricks dotnet20

5. Run:

wine ./dbforgemysqlru.exe (installs with no visible issues)

5 Responses to “dbForge Studio for MySql on Linux family operating systems”

  1. Rui Marques Says:

    Greate. Waiting for a full functional version on linux.

    With current mono evolution why not a full port to Mono enabling MAC, WIN and Linux users to enjoy this great tool?

  2. Dejan Lekic Says:

    This is a major stopper for me to buy this product, FYI. As Rui wrote above, I honestly see no reason why not simply port to Mono and provide support to all platforms Mono works on…

  3. frozenjim Says:

    Given the high percentage of developers who use Linux and Mac as their preferred platform, it seems less profitable to write this type of tool for only the Windows environment.

  4. Andrey Langovoy Says:

    Hi,

    Currently we do not have any plans to develop native applications for MAC and Linux. However, you can use dbForge Studio for MySQL together with MAC. For this you need Parallels Desktop for Mac.

    If you have additional questions, please let us know.

    Thank you!

  5. M.Weineman Says:

    did not work with actual wine versions and prevent me from buying. I really like dbForge but i don`t pay for a Windows exclusive program, since i mostly work on my Ubuntu Notebook. sad, but i`ve to evaluate some other, linux able SQL Studio

Leave a Reply