March 12, 2011 at 5:44 pm
Hi folks,
I have the sql server 2005 database with images loaded in the varbinary datatype in the tables.Can anyone help me in pulling these images and storing them in windows NTFS file system using the tsql ?
March 13, 2011 at 3:49 am
It's not all T-SQL, but have you tried SQL Image Viewer? Recognizes BMP, JPG, GIF, PNG, TIFF, and PSD images by reading the image data, supports SQL Server, Oracle, MySQL, PostgreSQL, and DB2, allows you to name your exported files using tags, and also allows you to transform your images (resize, adjust brightness, rotate, remote metadata etc) prior to saving them to disk.
And it can identify and export pdf, html, xml, mp3, wav, 7z, bz2, gz, rar, zip and unprotected MS Office documents (doc, docx, docm, dotx, dotm, xls, xlsx, xlsm ...) types too.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
December 15, 2011 at 1:35 am
You can use <IMG> tag to display images stored in the database by calling another ASP page in SRC attribute of <IMG> tag. Also, To directly use the binary data as a an image source, you can use the data URI scheme, for example:
$url = 'data:image/png;base64,'.base64_encode($row['binary-data']);
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply