Answer the question
In order to leave comments, you need to log in
Move blob field?
Greetings.
It is necessary to transfer from MS SQL server to MySQL server a table that stores files with different files in a field with the BLOB type.
If you upload this data to CSV and upload it to MySQL, then when php tries to give it to the user, you get "broken" files.
What is the best way to organize such a transfer, if possible. Or maybe before submitting, the user needs to perform some additional manipulations in php with the data from the BLOB field that is already in MySQL?
Navicat (1) and DBeaver (2) tried to unload the dump. Available options for uploading binary data in the screenshot:
Answer the question
In order to leave comments, you need to log in
Use the SQL Server Data Import and Export application included with MS SQL.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question