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.
If you are using Oracle Enterprise Linux, RedHat,
CentOS, and similar, you must have the EPEL repository
set up in yum for it to find the
libiodbc-devel package. For
additional information about this step, see
Installing Oracle Enterprise Linux and similar.
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 ODBC Administrator so that the ODBC subsystem recognizes it. Open ODBC Administrator from the migration tab in MySQL Workbench.
The name of the driver file is
libtdsodbc.so and it is located in
/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. Remember
the name you define here as it will be needed later on.
Save the driver.
Only the driver file name is required, while the setup file name can remain undefined.
Close the ODBC Administrator and click Start Migration. For information about making a Microsoft SQL Server connection using the MySQL Workbench migration wizard, see Section 10.5.3.2, “Linux”.