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 (SQLBlobViewerViewerCmd.exe)
you can use to automate your export tasks.
To start off, first write and execute a query to retrieve the data set you want to export in the SQL Blob Viewer GUI.
Let’s say we want to export out customer details into an Excel spreadsheet.
On this page, you can define the stored values which is used to support incremental exports. In this example, we’ll just
use the same query every time to export the data into the spreadsheet. Click on the Save to file... button to save the
settings to disk.
How to automate your export tasks (Professional Edition required)
Set up your export settings according to your needs. On the Summary page, click on the Save settings... button.
Once you’ve saved the settings, you can test the export by clicking on the Test settings button. SQL Blob Viewer will
use the saved settings file to run an export using the command line interface.
•
Check that you are using SQLBlobViewerCmd.exe and not
SQLBlobViewer.exe
•
Enclose the entire path and file name in double quotes.
For the ‘Start in’ value, enter the SQL Blob Viewer folder
name, but DO NOT enclose the value in double quotes.
Enter the full path and file name of the export settings
file as the argument, enclosed in double quotes.
Once set up, try running the task manually to check that it can run successfully.
SQL Blob Viewer supports incremental exports i.e. export only new data that has been added to your database. See
here for details on how to set up configure your settings file to support incremental exports.
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
Once we have retrieved the results, click on the Export to Excel button.
You can also run the settings file by using the command-line interface directly.
The fully qualified name of the export settings
file.
The name of the SQL Blob Viewer command
line interface executable.
Once you see the settings are running without errors, you can then schedule the export process to run periodically
using the Windows Task Scheduler.