Connecting SQL Server 2012 to MySQL I have 2 devices, a server computer installed with SQL Server 2012, and a raspberry pi with MySQL installed. I have data in MySQL tables. How can I connect SQL Server 2012 to MySQL so I can save that data?
One easy way to do this is with HeidiSQL, which can connect to SQL Server and MySQL and is free and open source (https://www.heidisql.com/). Once you set up both connections, you can use the Export Database As SQL feature to transfer data directly between databases.


In the Session Manager, set up the connection to the MySQL and SQL Server computers
Connect to the MySQL server, right-click on the server in the browser on the left, and select "Export Database As SQL". 
in the table list, select the table(s) you would like to export
in the Output: on the right, you will see a list of all servers you have configured in the Session Manager. Select the SQL Server 2012 instance.
You will probably want to keep the database the same so leave it as [Same as on source server]
You likely will want to check the create boxes for both database and tables if this is the 1st time you are transferring data
If you want to transfer the data and not just the table structure, in the Data: dropdown select the option that is best for you. I usually use Delete + insert (truncate existing data), but your needs may be different.
Click Export in the bottom right


That should do it.