MySQL Workbench 6.0 – A Sneak Preview

The MySQL Workbench team has been a little quiet for the past few months, but that's because we've been busy working on an exciting new version. Read more about it in Tomas' blog

Posted in News | No Comments »

MySQL Workbench team hiring C++ and/or Python developers

The MySQL Developer Tools team at Oracle is looking for good C++ and/or Python developers to help with the MySQL Workbench project. In the Workbench team, you'll be responsible for developing features, maintaining the existing codebase and interact with the community to improve the project. We're looking for candidates to work from office at Guadalajara, Mexico or from home in Romania, Ukraine, Portugal, Poland or Czech Republic, with availability to start in the team in late May. Job Description Software Developer, MySQL Workbench Software Development position responsible for development and maintenance of Python and/or C++ code for the MySQL Workbench product. Requirements * 5+ years experience developing solid Python or C/C++ code * Experience developing desktop GUI applications * Good knowledge of the C/C++ language * MySQL database development ...

Posted in Community | No Comments »

Installing a driver for Microsoft SQL Server and Sybase ASE in Linux and Mac

In a recent post we showed you how to migrate a SQL Server database to MySQL. There, we used the oficial Microsoft ODBC driver and that's OK if you are running MySQL Workbench in Windows. But what if your desktop OS is some Linux variant or Mac OS X? It turns out that Microsoft has recently released an ODBC driver for Linux. However, you can't use this driver with MySQL Workbench for Linux. (Actually you can, but you would have to rebuild Workbench). The main reason is that this ODBC driver was linked against unixODBC (an ODBC driver manager), while Workbench uses another ODBC driver manager: iODBC and the two of them can't coexist in the same system. So for Linux and Mac we prefer to go ...

Posted in Linux, Mac, Migration, Tutorial | No Comments »

MySQL Workbench 5.2.47 released

The MySQL developer tools team announces the availability of version 5.2.47 of the MySQL Workbench GUI tool. This is a minor maintenance release, addressing a problem during data copy in databases with triggers, during migrations and server upgrades. For a full list of issues fixed in this release, see the release notes. Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench and other MySQL products. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux. http://dev.mysql.com/downloads/workbench/ Workbench Documentation can be found here. Utilities Documentation can be found here. If you need any additional info or help please get in touch with us. Post in our forums or leave comments on our ...

Posted in Announcements | 1 Comment »

MySQL Workbench 5.2.46 released

The MySQL developer tools team announces the availability of version 5.2.46 of the MySQL Workbench GUI tool. This version contains 30 resolved bugs and support for the new MySQL 5.6 server. Additionally, MySQL Utilities 1.2.0 have been included on the distribution. For a full list of issues fixed in this release, see the release notes. Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench and other MySQL products. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux. http://dev.mysql.com/downloads/workbench/ Workbench Documentation can be found here. Utilities Documentation can be found here. If you need any additional info or help please get in touch with us. Post in our forums or leave comments ...

Posted in Announcements, News | 5 Comments »

MySQL Workbench 5.2.45 GA Released

The MySQL developer tools team announces the availability of version 5.2.45 of the MySQL Workbench GUI tool. This version contains various fixes and minor enhancements and includes 72 resolved bugs. This version contains the following significant updates: - Support for several new MySQL 5.6 features - Import recordsets from CSV file for the Inserts editor in Modeling and in the SQL Editor - Improved trigger editor - more Additionally, MySQL Utilities 1.1.1 have been included on the distribution. For a full list of issues fixed in this release, see http://dev.mysql.com/doc/relnotes/workbench/en/wb-news-5-2-45.html Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench and other MySQL products. Sources and binary packages are available for several platforms, including Windows, Mac OS X ...

Posted in Announcements | 1 Comment »

How-To: Migrate PostgreSQL databases to MySQL using the MySQL Workbench Migration Wizard

MySQL Workbench 5.2.41 introduced the new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. As of Workbench 5.2.44 you can migrate databases from Microsoft SQL Server, PostgreSQL and Sybase Adaptive Server Enterprise. It also provides for generic migrations, i.e. migrations from other RDBMSes that are not explicitely supported, provided that they have a well behaved ODBC driver. More on this in an upcoming post... Additionally, you can use the Migration Wizard to perform MySQL to MySQL database migrations, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL. We have already described in a previous post how to use the Migration ...

Posted in Migration, Tutorial | 2 Comments »

Set up and configure PostgreSQL ODBC drivers for the MySQL Workbench Migration Wizard

If you plan to use the MySQL Workbench Migration Wizard to migrate databases from PostgreSQL to MySQL you first need to configure an ODBC driver to connect to your PostgreSQL server. In this post I'll cover how to set up and configure psqlODBC, the official ODBC driver for PostgreSQL. Installing the psqlODBC Driver The procedure is different for every platform so make sure to follow the instructions that correspond to the OS where you have MySQL Workbench installed. The driver needs to be installed in that machine, as explained in the MySQL Workbench documentation. Windows If you are running MySQL Workbench on Windows download the MSI package for psqlODBC. Go to its download page (http://www.postgresql.org/ftp/odbc/versions/msi/) and pick the most recent file from the list. (The ...

Posted in Uncategorized | 1 Comment »

Installing MySQL Workbench in Ubuntu 12.10

Last month Ubuntu 12.10 was released and we tried to install MySQL Workbench on it. So we went to http://www.mysql.com/downloads/workbench/ and downloaded the .deb file for the most recent Workbench version (5.2.44 as of this writing). We then opened the .deb file with the Ubuntu Software Center application and tried to install it. Unfortunately the following message appeared: Dependency is not satisfiable: libctemplate0 The problem here is that the libctemplate package provided by Ubuntu 12.10 corresponds to a higher version (libctemplate2). Installing this version instead wouldn't work since MySQL Workbench is linked against the older one. We'll handle this dependency issue in future releases, but here's a workaround: Download the previous libctemplate version from here for 32 bits or here for 64 bits. Open the .deb file with ...

Posted in Linux | 5 Comments »

MySQL Workbench 5.2.44 GA Released

The MySQL developer tools team announces the availability of version 5.2.44 of the MySQL Workbench GUI tool. This version contains various fixes and minor enhancements and includes 8 resolved bugs. This version improves the Migration Tool to support additional RDBMSes - PostgreSQL 8.x and 9.x - Sybase Adaptive Server Enterprise 15.x - Any RDBMS that implements the INFORMATION_SCHEMA views from the SQL-92 standard Additionally, MySQL Utilities 1.1.0 have been included on the distribution. For a full list of issues fixed in this release, see http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux. http://dev.mysql.com/downloads/workbench/ Workbench Documentation can be found here. http://dev.mysql.com/doc/workbench/en/index.html Utilities Documentation can be found ...

Posted in Announcements | 7 Comments »