Extracting images and binary data from a database is a thankless and tedious task.  The standard database tools cannot even display images, much less identify the type of data that’s stored in a blob field.  And when you have gigabytes of data to extract, the last thing you need is for the tool to retrieve everything to your computer before exporting it. Do what the companies mentioned above have done.  Use SQL Image Viewer.  It simply excels at exporting large volumes of images and binary data from your databases. Here are some of the reasons why you’ll be smiling when using SQL Image Viewer: Latest release Version 3.4 released on June 11, 2010.  SQL Image Viewer Retrieve, view, and export images and binary data from your database Copyright © 2009-2010 Yohz Ventures Sdn Bhd. All rights reserved. All product and company names are trademarks or registered trademarks of their respective owners. Subscribe to our RSS feed. Use SQL to extract your data We know you’re pros in SQL.  You want complete control over what data is exported.  In SQL Image Viewer, you’ll be using SQL commands to extract exactly what you need.  No dumb export of entire tables here, no siree. Identify common image and file formats SQL Image Viewer can display images stored as bitmaps, jpegs, gifs, pngs, photoshop images, and tiffs.  It can also identify binary data as pdf, html, xml, mp3, wav, 7z, bz2, gz, rar, zip and unprotected MS Office documents (doc, docx, docm, dotx, dotm, xls, xlsx, xlsm ...) types.  So don’t take a guess as to what your blob field contains.  SQL Image Viewer will simply show you. Stingy on memory You have a table with a million rows, each containing an image averaging 10 megabytes in size, and you need to export all the images.  Sounds impossible?  Not so with SQL Image Viewer.  Where possible, it will retrieve the data in small batches, export them, discard the data, and retrieve the next batch.  Like we said, it simply excels in exporting large quantities of binary data. Connects to most popular database servers If you work in a environment that uses database servers from many different vendors, you’ll be happy to know that SQL Image Viewer has support for Firebird, MySQL, Oracle, SQLite, SQL Server, DB2 and PostgreSQL database servers.  And if your database server is not one of the above, SQL Image Viewer can still connect to your database if it has an ODBC driver. Supports scheduled tasks If image/binary data extraction is a regular task for you, you can easily schedule a task using Windows Scheduler or similar tools, to run SQL Image Viewer unattended at periodic intervals to extract the required data.  SQL Image Viewer has quite a bit of smarts too, if you need to export only new and/or modified rows. and so much more ... including inspection of images and binary data, configurable image processing functions, dynamic memory monitoring, non-blocking SQL execution, listing of image EXIF properties, auto-discovery of tables containing blob data and more. Download a trial copy now and experience how SQL Image Viewer makes retrieving, viewing and exporting images and binary data from your databases such an enjoyable and painless task. If you would like to know more about how SQL Image Viewer can help you in your binary data extraction task, this page gives you more details and includes actual screenshots from the application, You can also download just the help file using this link, so that you can browse through our documentation without having to install anything.  We have even posted the help file on-line in browseable HTML format, if you would prefer not to download anything at all at this point. There are also a couple of videos which shows you how to complete certain data extraction tasks which we hope you find useful. Finally, if there is anything at all you would like to ask, please do contact us. There’s really no substitute to actually using SQL Image Viewer to experience its benefits, and discovering a great addition to your database ‘power-tools’ kit.  Download a trial copy now (it’s only 9 megabytes, and you don’t need .net or java installed) And in case you’re wondering, it isn’t just multinational electronics companies that are using SQL Image Viewer.  Other companies/instituitions using SQL Image Viewer include: - Englewood Hospital and Medical Center - Rockhurst University - Commerce Bank - ISSAC Medical - Endicott College - Devcon Security - Touchette Regional Hospital - Pennsylvania Highlands Community College - Union College - Wisconsin Bench - Harper College - Concordia College - New York