Migrating BLOB data from MS SQL Server to MySQL

There is a remote MS SQL Server that I have read access to. It has thousands of pictures in a BLOB- one of the many problems being that they are in datatype image.

I want to transfer all of that BLOB data to a loc开发者_如何学编程al MySQL BLOB. I have tried using php mssql_connect (which is pretty broken) to no avail, I have also hunted down a copy of textcopy.exe; however, textcopy.exe only gives me the data as a photo-- not as the raw BLOB/HEX data. What is the best way of doing this, so that I can run it whenever I want to bring over more data as it is added to the MS SQL Server DB?

---

Try Data Import tool in dbForge Studio for MySQL. Select an ODBC data import format, configure ODBC connection to MS SQL database, and try to migrate data into MySQL.