CODEWITHSUNDEEP
sql-server
aneuryzm
aneuryzm

Reputation: 64834

SQL Server: how to export a table

how can I export a SQL Server table to Mysql ? I guess I need to export a .sql file compatible...

thanks

Upvotes: 0

Views: 225

Answers (3)

masoud ramezani
masoud ramezani

Reputation: 22920

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

MSSQL to MySQL

Upvotes: 0

aneuryzm
aneuryzm

Reputation: 64834

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

Upvotes: 2

Mladen Prajdic
Mladen Prajdic

Reputation: 15677

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.

Upvotes: 1

Related Questions