uwe
uwe

Reputation: 4097

How to import a MS SQL server table into mysql?

I need to export about 300,000 rows from a table on MS SQL server and import into mysql on a different server (non windows). There is some text stored in some fields and commas in the text will mess up the format if I export into txt format.

I can't install any software on the server.

Upvotes: 0

Views: 1958

Answers (2)

Oleg Dok
Oleg Dok

Reputation: 21776

You may have several options:

  • use SSIS or DTS Wizard on another host to interconnect MSSQL and MySQL
  • write your own small app to move the data
  • script the MSSQL DB's DATA into script file with SSMS' scripting features, adopt the script manually to mysql and run it

Upvotes: 1

Mr Moose
Mr Moose

Reputation: 6354

I'm pretty sure you can connect to MySQL from SSIS. I'd go down that route.

Upvotes: 1

Related Questions