Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
verybrightstar
Starting Member
16 Posts |
 Posted - 2004-06-24 : 14:31:48
|
| I have to convert all the images stored in SQL Server as blob ( binary ) to image file and stored in the directory.I have a table in MS Access DB which the table called Articles_Image Table . These are the following fields in Article_Image TableArticle_Image-------------------JPGname (PK) | Jpgdoc | CatDescNo | CategorySlnoI have import the Access database to SQL Server, i would like to know if SQL Server can able to provide either DTS services or using stored procedures to convert all those images stored as binary (BLOB) stored in Article_Image Table in SQL Server to a JPG image and stored in my folder example c:\imagesEach image file name is derived from the JPGname data. All the images are originally derive from JPG file.The reason is i need to retrieve all those images stored in the database to a real picture file for editing purpose."kt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-24 : 14:36:35
|
| You will not be able to do this with T-SQL or with DTS. You'll need to code a front-end application that can get the images out. I believe www.asp.net has examples of how to get the images out. I'm sure the code can easily be modified to save the images to disk.Tara |
 |
|
|
|
|
|
how to convert blob (binary) to image file