I recently needed to migrate some data I had in a SQL Server 2005 database to MySQL. After some searches online, I found the MySQL Migration Toolkit which now comes bundled as a part of the MySQL Workbench application. I thought it would be a straight forward process, however I hit a serious roadblock at the point where I needed to provide the connection details for my SQL Server 2005 database. After many Google searches, I have found how to go about resolving this issue.
First, you must bring up the RUN dialog (Shortcut:
+ R) and type “compmgmt.msc” without the quotes, and hit Enter. The Computer Management window should now appear. In the list to the left of the window, find Services and Applications node. Double-click it to reveal its sub nodes. Double click SQL Server Configuration Manager node, then SQL Server 2005 Network Configuration, then Protocols for SQLSERVER2005 (SQLSERVER2005 is the named instance of my SQL Server 2005 installation. Yours may be named differently.).In the right pane of the window, you will see the various protocols SQL Server uses and their current status. We are interested in the TCP/IP protocol, so right-click it and select Enable. Now right-click TCP/IP again and select Properties. In the Properties window, select the IP Addresses tab. Under IP1 and IPAll sections, set the TCP Port to a value of 1433.
Once you have done this, you must stop and restart the SQL Server 2005 database service. To do this, double-click the SQL Server 2005 Services node under the SQL Server Configuration Manager node. In the right pane, the SQL Server process and select Stop. After it has stopped, right-click again and select Start to restart the service.
You should now be able to connect to you SQL Server 2005 database with the MySQL Migration Toolkit with no problems.
