Database Software

Export to a Database

In Exportizer Pro and Exportizer Enterprise, in addition to exporting data to different file formats, you can also export to relational databases: either to the same database or to another one. It can be Access to SQL Server, Interbase to Oracle, CSV to PostgreSQL, or almost any other database-to-database conversion.

Exporting to database (PostgreSQL)

There is a set of database specific export options. For example, Export mode controls the export actions:

REPLACE+INSERT Target table is created and filled with incoming rows; if target table already exists, it is overwritten.
CREATE/REPLACE Blank target table (using appropriate structure) is created; if target already exists, it is overwritten.
APPEND Target table is appended with incoming rows; if target table does not exist, it is created.
EMPTY+INSERT Target table is emptied before inserting incoming rows; if target table does not exist, it is created.
UPDATE The records in the target table that match incoming records, are replaced with incoming records.
APPEND+UPDATE The records in the target table that match incoming records, are replaced with incoming records. Unmatched incoming records are appended to the target table.
DELETE The records in the target table that match incoming records, are deleted.

Exportizer Enterprise has a powerful Batch mode option which can increase the speed of the data transmission for some database types up to several hundred times.

Export Several Tables to One File

In Exportizer Enterprise, you can export a set of selected tables at a time. They can be exported either to files or to a database of your choice.

When exporting the tables to files, you can choose either to export them to different files (one table per file) or to one target file. The latter option is available for XLSX, HTML, and RTF destination formats.

To export multiple tables to another database (e.g. MySQL, Oracle, Access, SQLite etc.), pick Database target format and choose the needed destination database.

Exporting several tables to one file

Export Huge Tables

In many export tools, exporting huge tables require extensive memory usage and can sometimes cause the operating memory overflow.

Exportizer Enterprise can solve this by utilizing so called Live Data Window mode. In this mode, only current screen of records is kept in memory, and memory usage does not increase when scrolling and exporting the table. This mode not always can be applied and works slower but can help in most cases.

Exporting huge tables

Field Mappings

Before exporting data, it is possible to specify the mappings between source and target fields.

Here, you can also add custom calculated fields and even specify an individual destination file for each source field. [Pro, Enterprise]

If you remove any mapping from the list, the corresponding item will not be exported.

If you skip this step, the software builds the mappings itself.

Field mappings for Access to PostgreSQL exporting

When exporting to relational databases, this data export tool can convert the source column types to target column types (see example of Access to PostgreSQL data migration on the screenshot). But anyway, it is possible to specify full target columns' specifications manually. [Pro, Enterprise]

When exporting multiple tables, it is possible to specify the table mappings. [Enterprise]

Field or table mappings can be saved to file and loaded from file.

Export Images and Other Blob Data

Exportizer Pro and Exportizer Enterprise can automatically detect the most known image types (JPG, PNG, GIF, BMP, ICO) in BLOB fields of a source database and export them, for example, to HTML, Excel, or RTF. They can also convert image format on the fly.

There is a possibility to export Blob data (images, large text, etc) into separate files in one export operation. In general, you can export each field in each record to an individual file.

to HTML: Exporting images from Access to HTML
to RTF: Exporting images from Access to RTF

Export Data to HTML Using Template

Using HTML template allows producing highly customizable output, therefore target HTML file can be used directly in frontend without any further tuning.

Export from dBase to HTML using template

Export Dialog

It is possible to choose the output format and specify many common export options as long as options specific to selected target format.

Main window and Export dialog

Selecting Data Source

In Select Data Source dialog, you choose the database engine which you want to use for opening your data source and the data source like a folder with data files (e.g. .dbf or .csv), multi-table database file [Pro, Enterprise], ODBC DSN [Pro, Enterprise], ADO connection string [Enterprise] etc.

Some database types can be opened by different database engines. For example, Oracle databases can be opened by FD [Enterprise], ADO, or BDE. We recommend to use FD whenever possible, but you might want to try different engines and compare which is better for your work.

Selecting data source

SQL Editor

Exportizer Pro and Exportizer Enterprise allow you to write custom SQL queries. The result of the SQL query can be exported like it is done for a table from the table list. SQL editor gives you all you need to comfortably write the queries: SQL syntax highlighting, UNDO feature, loading and saving files, supporting of SQL parameters, storing history of executed queries etc.

SQL editor

Export Menu

Export menu gives you an ability to choose what to export: current table or SQL query result, several selected tables [Enterprise] or even all tables [Enterprise] of the database at once. You can also copy the data from the opened data source to clipboard.

Export menu

Tools Menu

In Tools menu, there is a set of useful functions to operate with data: bookmarking, duplicating data, pasting tabular data from clipboard (copied from Excel, for example), printing data etc.

Tools menu

Building Command Line for Data Export

Export operations can be performed also via command line. You can easily build needed command line directly from the GUI using interface very similar to regular Export dialog.

For your convenience, the command line parameters can be saved to action file. It is possible to execute action files either from command line or from GUI. You can create action files for different export cases and use them whenever you need to repeat your export actions.

Creating command line from GUI