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.