How to export a SQL Server 2008 image field to a pdf file?

I have a table with an image field that is used to store pdf files in binary format. I have successfully imported a pdf file into the image field using openrowset. Then I successfully exported it to a binary file using BCP in a SQLCMD window.

Now my problem is how to get the exported binary file into pdf format so Adobe can read it, and I can confirm that I have the same file I started with.
chi5927Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
chi5927Connect With a Mentor Author Commented:
I don't think there's any way to do this other than programmatically. I'm going to try writing a little utility program to do the job. If that doesn't work I will re-post the question.
0
 
dannygonzalez09Commented:
found an article which i think might help you

http://www.sqlservercentral.com/articles/BCP/63560/
0
 
chi5927Author Commented:
I have seen nothing in any of the articles I read to indicate that it's possible to do this in native SQL. I have some code from another application that does it programmatically so I'm going with that.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.