SQL Server: how to export a table

how can I e开发者_JS百科xport a SQL Server table to Mysql ? I guess I need to export a .sql file compatible...

thanks

Solution: Right Click on database Icon > Tasks > Generate Scripts follow istructions and export a specific table as .cvs

One way is to BCP the data out into a CSV or some other format flat file and import those into mySQL.

Another way is to use a SSMS add-in called SSMS Tools Pack which has the option to generate insert statements.

please see the below link, maybe it can help you.

MSSQL to MySQL