Microsoft Windows

Microsoft Windows XP and newer includes at least one ODBC driver for Microsoft SQL Server, so additional actions are likely not required on your system. Multiple SQL Server driver options exist, as described below.

You can check your ODBC driver information by starting the Windows ODBC Data Source Administrator that is linked from the MySQL Workbench migration wizard's home page. Alternatively, open a Windows terminal and execute odbcad32.exe. Open the Drivers tab to see something similar to:

Figure 10.41 Windows ODBC Data Source Administrator: SQL Server Drivers

Windows ODBC Data Source Administrator: SQL Server Drivers

Common ODBC drivers available on Windows are:

Decide which driver you want to use, and remember its name as shown in the ODBC Data Source Administrator. This specific name is used in MySQL Workbench to connect your SQL Server instance.

Jump to the documentation titled Section 10.5.3, “Connection Setup”.