© 2005 - 2012 Yohz Software, a division of Yohz Ventures Sdn Bhd
Products > SQL Image Viewer > Overview
Overview Details Download Purchase Help file
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:
Use SQL to extract your data
We know you’re experts 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. Learn more.
Identify common image and file formats
SQL Image Viewer can display and export images stored as bitmaps, jpegs, gifs, pngs, photoshop images, and tiffs. It does this by reading
the binary data directly. You don’t have to tell it what format your images are stored in. It can also do the same for binary data stored 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 worry if you don’t know what your blob field contains. SQL Image Viewer will simply show you.
Low memory usage
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 batches, export them, discard the data, and
retrieve the next batch. It does not wait to retrieve the entire data set into memory before exporting it. Like we said, it simply excels at
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 types, SQL Image Viewer can still connect to your database if it has an ODBC driver. Learn more.
Supports scheduled tasks (Professional Edition only)
If exporting image/binary data 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 i.e. appending conditions to the WHERE portion of your SQL command. Learn more.
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, and auto-discovery of tables containing blob data.
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.
Finally, if there is anything at all you would like to ask, please do contact us.
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:
- PricewaterhouseCoopers AG
- Texas Tech University
- Pfizer
- University of Maine
- 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
Download a trial copy now and experience how SQL
Image Viewer makes retrieving, viewing and exporting
images and binary data from your databases a painless
task.
Extract and save your images and binary data to disk
SQL Image Viewer can save all your binary data to disk, or only the types you specify. In addition, it can convert images to other formats, and
also perform some simple image processing functions, prior to saving the images to disk. Learn more.
Generate an Excel spreadsheet of your exported data
During the export process, SQL Image Viewer can also generate an Excel spreadsheet of your result set, with links to the exported items.
This spreadsheet is generated without having the need to install Microsoft Excel or any MIcrosoft Office components on your machine.
Learn more.
Products > SQL Image Viewer > Overview
Overview Details Download Purchase Help file
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:
Use SQL to extract your data
We know you’re experts 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. Learn more.
Identify common image and file formats
SQL Image Viewer can display and export images stored as bitmaps, jpegs, gifs, pngs, photoshop images, and tiffs. It does this by reading
the binary data directly. You don’t have to tell it what format your images are stored in. It can also do the same for binary data stored 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 worry if you don’t know what your blob field contains. SQL Image Viewer will simply show you.
Low memory usage
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 batches, export them, discard the data, and
retrieve the next batch. It does not wait to retrieve the entire data set into memory before exporting it. Like we said, it simply excels at
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 types, SQL Image Viewer can still connect to your database if it has an ODBC driver. Learn more.
Supports scheduled tasks (Professional Edition only)
If exporting image/binary data 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 i.e. appending conditions to the WHERE portion of your SQL command. Learn more.
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, and auto-discovery of tables containing blob data.
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.
Finally, if there is anything at all you would like to ask, please do contact us.
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:
- PricewaterhouseCoopers AG
- Texas Tech University
- Pfizer
- University of Maine
- 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
Download a trial copy now and experience how SQL
Image Viewer makes retrieving, viewing and exporting
images and binary data from your databases a painless
task.
Extract and save your images and binary data to disk
SQL Image Viewer can save all your binary data to disk, or only the types you specify. In addition, it can convert images to other formats, and
also perform some simple image processing functions, prior to saving the images to disk. Learn more.
Generate an Excel spreadsheet of your exported data
During the export process, SQL Image Viewer can also generate an Excel spreadsheet of your result set, with links to the exported items.
This spreadsheet is generated without having the need to install Microsoft Excel or any MIcrosoft Office components on your machine.
Learn more.