How to copy a table from SQL Server into MySQL?

You have a few options:

1. Set up a linked servers on SQL Server against the MySQL db, and then join the data as needed on the SQL Server side
2. Having set up the linked server, you can also copy the table over to a new location using standard SQL (or create a table in MySQL and copy data in).
3. You can also use Data Transformation Services in SQL Server to export into a csv or similar, to import in MySQL using a csv import tool.

Which one is best depends to some extent on size of the record set and how much of it you need. My preference would be to use DTS and go from there.

It would be better to do this using bulk export and import operations, instead of row by row.

Here are references to some relevant Stack Overflow posts that describe how to do each step:

• Export from SQL Server 2012 to .CSV through Management Studio
• How to import CSV file to MySQL table

You can try it with SQL Server Management Studio by using the Export Import Wizard.

SQL Wizard

In this case, you will use the SQL Server database table as the source, and the MySQL database table as the destination.

Many server administration tools including SQL Server Management Studio for Microsoft SQL server and phpMyAdmin include tools to export a tables content into another form such as XML,json, csv, and so on. They also allow one to import data from the same types of files. This would be the simplest route, especially with just one table.

Another option is an ETL tool. If you are familiar with Java you could use an open source tool such as Talend Open Studio for Data Integration to create jobs that can configure connections and a job that will automatically move or copy the data from one database to another, and also gives you more control if you need to filter or change any of the data along the way.