• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 958
  • Last Modified:

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.
0
chi5927
Asked:
chi5927
  • 2
1 Solution
 
dannygonzalez09Commented:
found an article which i think might help you

http://www.sqlservercentral.com/articles/BCP/63560/
0
 
chi5927Author 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
 
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now