How To Export Database Contents with Embedded Images

Most people rely on database software to organize, store and manage important information of their businesses or even for personal usage. Common software databases are Oracle, Microsoft Access, Lotus Approach, Sybase and Microsoft SQL. If you are one who uses a database, you might find that the software you are using may have its limits. Some of the software cannot export embedded images to another format. You may have a query on this to software companies but most of them answer you that the database export tools are still being developed. But don’t throw a fit just yet. You need to export all data including the images from the database to another format but how? A solution to this is the SQL Image Viewer. This tool is downloadable from the Internet at Brothersoft. However, this tool is shareware, you may use the trial version for a limited time. So how will you use it? Here’s how with SQL Image Viewer.

  1. Open the SQL Editor. Load an SQL script in the editor tab. You can enter it manually or click the “load script” button on the toolbar. Once you complete the scripts, click on the “execute” button or F5. If you don’t have any errors on the script, the run will execute smoothly, otherwise you have to double check your script. Once it is executed and does not contain any error on its syntax, the results tab will open.
  2. View and/or edit the images in the Results tab. You can view the thumbnails of the images in three layouts: thumbnail, tiled and filmstrip. However you want to view the images does not affect the functionality of the tool. This tool supports most formats of images such as BMP, GIF, JPEG, PNG, TIFF and PSD (Photoshop file). You can also edit your images in this tool. You can adjust its brightness, contrast, rotation and color. Before you export your image, you can be sure that it does not need to be edited anymore. This is one of the SQL Image viewer’s useful features.
  3. Export your images into your disk. You can first view the images individually by clicking on them. The image will open in a larger view with all its information at the left side of the screen. You can then choose which images you want to export. After the selection, right click to “save image” and save it to disk. Aside from embedded images, you can also view its binary data or you can switch the interface into a text view by clicking on the button “Results in Text.”

It is actually very helpful to use the SQL Image viewer because it works with almost all database software. It enables you to retrieve, view, convert and export images stored in databases like Oracle, MySQL, Firebird and other ODBC-supported databases (Open Database Connectivity). If your own database software allows exporting data, tables and database schema (for Oracle software) but limits your freedom to export images, the SQL Image viewer offers you that solution. With this kind of tool developed for database software, you feel almost limitless.


Share this article!

Follow us!

Find more helpful articles: