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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to get varbinary to .png

Author  Topic 

pushp82
Yak Posting Veteran

83 Posts

Posted - 2012-10-10 : 01:30:59
Dear all,

I have images in varbinary column and I need them in folder as .png. How to do this?

I tried BCP but could not succeed.

Please help! An immediate response would be applicable.
is it possible?

Thanks,

chadmat
The Chadinator

1974 Posts

Posted - 2012-10-10 : 02:07:38
Look into Filestream.

-Chad
Go to Top of Page

pushp82
Yak Posting Veteran

83 Posts

Posted - 2012-10-10 : 04:51:28
I did the job by BCP command:

DECLARE @Command NVARCHAR(4000)
SET @Command = 'bcp "SELECT PictureBinary FROM mcdonaldswosbkup.dbo.TABLE WHERE TABLEID = ' +convert(VARCHAR,82) + '" queryout "c:\Temp\Images\' + 'test.png' + '" -T -n -SSERVERNAME'
PRINT @Command -- debugging
EXEC xp_cmdshell @Command
Go to Top of Page

pushp82
Yak Posting Veteran

83 Posts

Posted - 2012-10-10 : 05:21:05
I did the job by BCP but it is just creating an icon of no image any solution guys???
Go to Top of Page
   

- Advertisement -