Prev: Copy SchemadataProNext: Import Text files to the Database

Import Images to the Database

Overview

This tool allows you to upload images or any other binary data to the current database. In other words it inserts binary data from the file into the BLOB type database field in the database.

Import images

Every time you run an insert it will create/recreate a temp_image table in the current database with two fields: File_Name and Picture. File_Name field contains the file name and Picture field contains the data from that file.

After the upload you can use regular sql syntax to move binary data from temporary temp_image table into your tables or you can alter the temp_image table in any way.

Here are sql statements application uses to create temp_image table:

MySQL: create table temp_image (File_Name varchar(60), Picture blob)
Microsoft® Access: create table temp_image (File_Name Text, Picture image)
SqlServer: create table temp_image (File_Name varchar(60), Picture image)
Oracle: create table temp_image (File_Name varchar2(60), Picture blob)

Selecting files for the upload

Click File button

Select file Dialog Box will appear. Select one of the files you want to upload to the database. The application will upload all the files in the directory where you have chosen the file with the same extension as the file you choose. For example if you choose file sample.gif in the directory c:\pictures dataPro will upload all gif files from that directory.

Uploading files

After selecting files for the upload you can click the Process button to start uploading. You will see the history in the list box window.

Prev: Copy SchemadataProNext: Import Text files to the Database