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
- 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.