Solved

convert binary file into readable format

Posted on 2011-02-13
3
721 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

809 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