troubleshooting Question

How to Convert 1000's of BLOBs to Image Files

Avatar of cbdrako99
cbdrako99Flag for United States of America asked on
Microsoft SQL Server
12 Comments1 Solution558 ViewsLast Modified:
Hello Experts,

I have been tasked with the challenge of exporting data contained in an existing medical practise managment database application (Lets call this application "A") into a form which can be imported into a new practice management application ("B").  There is no facility for exporting data out of "A", but by importing a backup file of "A's" database into a newly created MS SQL database, I have gained access to the raw data and I have worked out the mechanics of pulling the raw data and parsing it for import into"B".  

BUT my problem is that "A" stored scans of images and documents (growth charts, lab studies, letters and coorespondence, etc) as BLOBS.  There are several thousands of these BLOBS.  I cannot import the blob data into "B" as it is designed to store them in flat file form (.tiff or .pdf preferred).  

Does anyone know of a tool or application for accomplishing the conversion of blob data fields to image files?  I have heard that Visual Fox Pro may be capable of this, but I don't know VFP so that doesn't help a heck of a lot. (Any volunteers? :-) )

Note: "A" is constructed with MS SQL 2000.  "B" is built with MySQL.

PS. I am not a programmer by anyone's definition, so an off-the-shelf tool would be much preferred, but I'll take all the help I can get.  

Thanks in advance.
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros