We are trying to copy a blob
(binary data) from one Database to another Database using a simple script. This is the steps we do.
- Select the value using MSSQL Studio Client.
- Copy it into the clipboard.
- Paste it into an
INSERT
script usingnotepad
. - Apply it into the destination database.
We notice that the value is now an ASCII
that starts with 0x255....
which seems to be the hexadecimal
representation of the binary
data. Is there a way we can convert it back to binary during the insert?
Is there a better way to copy blob
data using scripts? Assume, we don't have direct connection to destination Database.
Best Answer
I would use the "Generate Scripts" option in SQL Server Management Studio.
I tried a simple test with a table storing a
varbinary
field. The output from the Scripting process looked ok: