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.

StackExchange Database Administrators Q#200007, answer score: 2