Solved

convert binary file into readable format

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

790 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