J
J
Johnick2019-02-13 16:15:16
MySQL
Johnick, 2019-02-13 16:15:16

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:
5c6417a5ee28b060107095.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Tsvetkov, 2019-02-13
@tsklab

Use the SQL Server Data Import and Export application included with MS SQL.

D
d-stream, 2019-02-13
@d-stream

There are two options:
- either spit out from the blob source in some kind of ascii encoding (for example, base64)
- or do something like mssql -> a script that can connect to both databases-> mysql

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question