[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

convert binary file into readable format

Posted on 2011-02-13
3
Medium Priority
?
741 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 1600 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 400 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

872 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