Question: how to export binary data sql server?
Answer: Select Tools > Data Transfer.
In the General tab, select the source connection, database and table, and choose Transfer to file / File.
Choose a location for the file.
In the Advanced tab, check Use hexadecimal format for BLOB.
Click Start.