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.