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 local 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.