cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

CAD file export from SQL BLOB

Participant

CAD file export from SQL BLOB

One of our legacy systems has crashed that was running Windchill 9.1 M050 software but the SQL system is still functioning. It appears that there was no backup. What I’m trying to do is export the CAD data from the SQL database. It appears that the database was never setup right as all the files are stared in BLOB in the database.

 

I’ve been able to write the query below that relates the columns from the tables in the database.

 

What I’m unsure of is how to get a usable file out of the BLOB data and write it to a file?

 

What I’ve read is that it must be converted to something varbianary>bianary>hex or something?

 

--query binding tables--

select

ad.fileName --table column with file name--

, sd.lobLoc --table column with file data this needs to be contents of file--

, e.nameB2folderingInfo --table column with folder name I’d be happy if everything was in a single folder this would just be nice to separate it to sub folders--

from

--everything below relates the above three table columns--

 wcadmin.EPMDocument e

, wcadmin.EPMDocumentMaster m

, wcadmin.HolderToContent h

, wcadmin.ApplicationData ad

, wcadmin.StreamData sd

where e.latestiterationInfo='1'

and e.idA2A2=h.idA3A5

and h.idA3B5=ad.idA2A2

and e.idA3masterReference=m.idA2A2

and ad.idA3A5 = sd.idA2A2

 

I’m not an expert in SQL I’m just a design engineer that is trying to recover the old data.

Thanks for any and all help!

 

-Greg