Solved

convert binary file into readable format

Posted on 2011-02-13
3
720 Views
Last Modified: 2012-05-11
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    
0
Comment
Question by:gpinfotech
3 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 400 total points
ID: 34886229
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
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 34886602
0
 
LVL 13

Assisted Solution

by:devlab2012
devlab2012 earned 100 total points
ID: 34888506
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now