Home Products Downloads Store Support Company and contacts Blog Videos SQL BLOB VIEWER
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
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
Download trial Buy now, from USD 45

View and export images and

files from your database with

SQL Blob Viewer

See help file
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.
Product details FAQ Comparison with SQL Image Viewer Compare editions Blog entries Videos