Setting up drivers on Linux.
FreeTDS version 0.92 or greater is required. Many distributions ship older versions of FreeTDS, so it may need to be installed separately. Additionally, the FreeTDS version provided by distributions may also be compiled for the wrong ODBC library (usually to unixODBC instead of iODBC, which MySQL Workbench uses). Because of that, you will probably need to build this library yourself.
A script is provided to compile FreeTDS using the options
required for MySQL Workbench. You can find it at
on Linux or
on OS X. To use it, follow these steps:
When compiling FreeTDS for use with iODBC (the default with
the official binaries), it must be compiled with the
--enable-odbc-wide command line. Failing
to do so will result in crashes and other unpredictable
errors. The provided
script does this for you.
For compiling, make sure you have the iODBC headers
installed. For Linux, the name depends on your system's
package manager but common names are
libiodbc-devel (RPM based systems) or
libiodbc2-dev (Debian based systems).
For OS X, the headers come with the system and no
additional action is required for this step.
mkdir ~/freetds to create a directory -
within the users home directory.
build_freetds.sh script to
Get the latest FreeTDS sources from
and place the
.tar.gz source file into
~/freetds directory. Make sure to
get FreeTDS version 0.92 or newer.
After compilation is done, install it using
install from the path given by the script.
Install the driver using the systems ODBC Administrator so
that the ODBC subsystem recognizes it. The name of the
driver file is
libtdsodbc.so and is
/usr/local/lib. For example, under
the ODBC Drivers tab click
Add Driver and fill out the
description (name) and path to the driver file:
Note that only the driver file name is required, while the setup file name can remain undefined.
Optionally, create either a User or System DSN using the ODBC Administrator. Link the ODBC driver created in the previous step, and at a minimum, also add the Port and Server keywords. To mimic the screenshot below, click Add under User DSN, choose the driver created above, and define (add) the "Port" and "Server" keywords:
This DSN will be discovered by the MySQL Workbench migration wizard when using Data Source connection method for your target schema.