In my web application (VS2008), I have to transfer result of a query in MS SQL 2005 from one MS SQL instance to another using a portable memory device (both servers are in different networks). The query results include images stored in varbinary(max) fields and varchar fields.
I looked at saving the query results in XML Files, Excel, and even Access 2007. Typical issue is handling of varbinary data. My research suggest that there is conversion issue between varbinary(max) in SQL 2005 and OLE Object in Access.
What would be the best way here? If any one has worked on this before, can you please share experience/code snippets?