You must install and then configure a Windows Data Source Name (DSN) for SQL Server’s ODBC before you can connect MySQL Workbench to a SQL Server and migrate data. If you fail to set it up, you can’t complete the first step of the MySQL Workbench migration wizard, as shown in the image to the right.
For MySQL readers, this was posted as part of a replicateable test case for Alfredo’s MySQL Workbench team. A Windows OS version of Bug 66516.
You configure a Windows Data Source Name (DSN) for Microsoft SQL Server 2012 after a successful installation (shown in this related blog post), by performing the following steps.
SQL Server ODBCas the DSN and description, and chosen the
localdatabase server. The local database server is the server running on the
localhostmachine. Click the Next button to continue the process.
Hopefully, this helps those learning how to set up Microsoft SQL Server to work with MySQL Workbench’s migration tool.