Groups > Databases > Oracle for ASP.NET > Re: Oracle Blobs to Physical Files




Oracle Blobs to Physical Files

Oracle Blobs to Physical Files
Tue, 11 Mar 2008 03:31:59 +000
Hi Everyone,

I am not sure if this is the right place to post my question.  I am currently
working on converting our existing Document Management web application into
ASP.NET.  I am actually almost done with the front end.  My concern now lies in
the backend which is having to migrate all our existing data to our new servers.
 To give you an idea, our previous Document Management webapp stores files as
BLOBS into our Oracle tables.  My dilemma now is doing the data migration.  I
need to know how I can convert all those BLOBs into readable files.  Does anyone
of you have any experience with this or have any idea of how I can achieve the
data migration?
Post Reply
Re: Oracle Blobs to Physical Files
Tue, 11 Mar 2008 04:25:19 +000
You need to read the BLOB data into a byte array and save it as a file.

An example

http://www.c-sharpcorner.com/UploadFile/scholar2015/Retrieve_Oracle_BLOB_and_sav
e_as_a_JPG_using_ASP_Net_208262006011330AM/Retrieve_Oracle_BLOB_and_save_as_a_JP
G_using_ASP_Net_2.aspx
Post Reply
about | contact