Reputation: 4097
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
Reputation: 21776
You may have several options:
Upvotes: 1
Reputation: 6354
I'm pretty sure you can connect to MySQL from SSIS. I'd go down that route.
Upvotes: 1