You can do this manually if you really want to. Get this hex editor http://www.box.net/shared/eugsmcip6i it's the only one I found that lets you past hex data.
Find the binary content in the database. Copy the content of the field into the hex editor and save the file with the proper extension. Make sure to tell HexEdit that you are pasting hex instead of text. But my guess is you're looking for something more automated to grab all the files and save to disk. I can give you some code that grabs binary data from db and saves to a file. Not sure how comfortable you are with editing the code to get it to read your specific data. Contact me off the list if you want some C# code. --T On Wed, Jul 14, 2010 at 1:24 PM, Cameron <[email protected]> wrote: > I've recently been sent a SQL database that contains all of our documents > from an externally hosted site and have been tasked with the job of > extracting said documents. I've found the table that lists them all and the > size/type (PDF, Word, Excel) but have NO idea on how to extract them into > their native formats. > > Any SQL guru's out there that can point me in the right direction? > > As always, any pointers greatly appreciated! > > Cheers, > Cameron > > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
