convert binary file into readable format

hi ,
    I need to convert the binary data into the readable format (image or text etc..).

  Actually my table contains a field of datatype image. this field stores the attachments in the binary format. Because of these attachments data base size is growing rapidly. now i decided to convert these binary fiels into readable format and store them in a separate drive.if it's possible by using sql coding then i store only that path of the file in my table.


thanks    
gpinfotechAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
That's indeed a good decision from your end..
Check the link below which indicates how to retrieve Images from binary fields using T-SQL.

http://madhuottapalam.blogspot.com/2008/08/creating-files-from-images-stored-in.html

Once images are retrieved, then you can update the reference paths accordingly in your actual table.

PS: Make sure that your images location are included in your regular server backup plans.
0
 
Alpesh PatelAssistant ConsultantCommented:
0
 
devlab2012Connect With a Mentor Commented:
Here is a very good post for creating files from binary data columns:


http://jahaines.blogspot.com/2009/10/exporting-binary-files-to-file-system.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.