1

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?

Improve this question

1 Answer 1

Reset to default
2

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you so much. I tried exporting that under the mssql management console and it's a POS. This worked perfectly. Mad props =)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.