Since there are a couple of options you would have to pass to the driver’s configure script, we have created a script file to help you pass this with no pain.Mac users can skip this step since the apropriate development files are already included in their system. $> yum install make automake gcc gcc-c++ libiodbc-devel If your distro uses rpm packages (Red Hat, Fedora, etc.) the command would be like this: $> su. $> sudo apt-get install build-essential libiodbc2-dev Try running this from the command line if your are using a Debian based distro like Ubuntu: If you are in Linux, make sure that you have installed the essential build tools (C/C++ compiler, linker, etc.) and the development files for iODBC.Save this tarball in a directory where you have write permissions (something like /home//freetds would do). We advise you to use the latest stable version rather than a nightly snapshot. Make sure that you have at least version 0.92. Go to the FreeTDS homepage and download a recent version of the driver’s source code.Fortunately, the process for compiling and installing it is pretty straightforward. Most distros provide fairly old FreeTDS versions and virtually all of them come linked against unixODBC, which is not supported by Workbench. In spite that you can find FreeTDS in the software repositories of several modern Linux distributions, you are encouraged to download it and compile it yourself. As a bonus, the very same driver can be used for connecting to Sybase Adaptive Server Enterprise, an RDBMS also supported in the MySQL Workbench Migration Wizard. So for Linux and Mac we prefer to go in a different direction and use FreeTDS, an alternate ODBC driver for Microsoft SQL Server. 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.
(Actually you can, but you would have to rebuild Workbench).
However, you can’t use this driver with MySQL Workbench for Linux. It turns out that Microsoft has recently released an ODBC driver for Linux.
But what if your desktop OS is some Linux variant or Mac OS X? There, we used the oficial Microsoft ODBC driver and that’s OK if you are running MySQL Workbench in Windows. In a recent post we showed you how to migrate a SQL Server database to MySQL.
0 kommentar(er)
