•
identifies most image formats and file types automatically
•
export unlimited images and files on demand
•
command line interface allows you to automate your export tasks
•
supports Access, Firebird, MySQL, Oracle, PostgreSQL, SQL Server,
SQL Server Compact, SQLite, and ODBC data sources
View and export images and
files from your database using
SQL Image Viewer
Products
Support
Get our Products
Copyright © 2005 - 2017 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED.
All trademarks or registered trademarks are property of their respective owners
Company
The SQL Blob Viewer Professional Edition license includes a command line interface (SQLBlobViewerCmd.exe) you can
use to automate your export tasks. Please see this page on how to set up an automated export task using the
Windows Task Scheduler.
When you set up the export settings in the GUI, the same query will be ran each time, and most likely the same data
set(s) will be returned. SQL Blob Viewer supports dynamic queries, where the SQL statement can be modified at run
time.
Let's use the following query as a starting point.
How to to export only new files and images in your scheduled export tasks
(Professional Edition required)
Option 2 - provide a list of integer values from a file
You do this using the <integerlist> tag. Say that you only want to export items with specific ProductPhotoID
values, and another application will provide this list of values. The requirement is that the application provides
one value per line e.g.
56
75
89
and stores this list in a file. For our example, let's assume the list is stored in the f:\export\list.txt file. You
would then need to modify your SQL to the following:
Get started with SQL Blob Viewer
Make working with blobs easier - try SQL Blob Viewer
free for 14 days
Got a question?
If you need help, or have any questions about
SQL Blob Viewer, please get in touch.
support@yohz.com
•
identifies images and file types automatically
•
identify images and files stored in OLE Object columns
•
export embedded images to Excel spreadsheets
•
supports Access, Firebird, MySQL, Oracle, PostgreSQL, SQL Server,
SQL Server Compact, SQLite, and ODBC data sources
View and export images and
files from your database with
SQL Blob Viewer
Option 1 - provide a file that contains a SQL query
You do this using the <file> tag. Instead of explicitly providing the SQL command to run, you can provide the
name of a file that contains the SQL command to use. You can use this option when you have other applications
that can dynamically generate the SQL command to use. Note that the query needs to contain any columns that
you may have used to name the exported files.
E.g. if your SQL command is stored in the f:\export\sql.txt file, you would modify the SQL to this:
When SQL Blob Viewer runs the export, the SQL query it will run will contain the values from the file i.e.
SELECT ProductPhotoID, LargePhoto FROM Production.ProductPhoto WHERE ProductPhotoID IN (56, 75, 89)
To use a list of text values, use the <stringlist> tag e.g.
Note that each text value in the file need not be enclosed in single quotes.
Option 3 - use self-incrementing values
In situations where you have a column that auto-increments each time, and you only need to export new items,
the SQL Blob Viewer command line interface can maintain a file that contains the last processed value for you.
That file can then be used as input to the SQL command.
Assuming that ProductPhotoID is a self-incrementing value in our example. Say we only want to export new
items each time the export runs. First, we need to modify the query to use the <integerlist> tag, to point to a file
that will hold the last ProductPhotoID value.
We also need to ensure that our data set is ordered, so that the last record holds the latest ProductPhotoID
value.
Next, we need to tell SQL Blob Viewer that we want to store the last ProductPhotoID value in the
f:\export\LastID.txt file. We do this by entering the values in the Stored values area.
Once you have saved your settings, you can test it by clicking on the Test settings button. SQL Blob Viewer will
run an export using the command line interface and the settings you have saved, and display the output.