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.