Database Export Tool
The Database Tour contains a very fast, highly customizable data export and data pump tool.
It allows you to export or migrate data to:
- New or existing table(s) in the same database.
- New or existing table(s) in another database of any supported type, e.g. Access, Oracle, SQL Server, PostgreSQL, SQLite, Firebird etc.
- File(s) of the following types: text, CSV, HTML, Excel (xls, xlsx), dBase (dbf), PDF, SYLK, RTF, XML, Word, SQL script.
- File(s) of custom format based on user's formula.
- Image and other separate files from database Blobs and Clobs.
Exporting to HTML, XLSX, PDF, and RTF can be performed with pictures and text formatting (including conditional formatting).
There is a possibility to export data using action files or in the command line mode (Database Tour Pro only). This allows to use the tool in .bat files, schedulers, and in calls from other programs, including your own ones.
You can import data from a table in the same or another database. Also, it is possible to import data files like .db, .dbf, .csv etc by dragging them into the table list of the open database. Importing works similarly to exporting, where input and output are swapped; therefore, in all cases where importing destination-db from source-db is needed, it can be replaced with exporting source-db to destination-db.
Exporting Data to Databases
Exporting Multiple Tables
In just a few clicks, you can easily export several selected tables at once. By default, exporting group of tables is done as one source table per one target file or table.
Exporting selected tables to one target file or table is also possible.
Exporting Images and BLOB Data
The program 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 or XLSX formats. It can also convert image format on the fly.
The data from BLOB, CLOB or other fields can be exported into individual files, binary or text.
Exporting to HTML Using Template
Exporting with Formatting
For more details about exporting data, please see Database Tour documentation:
Please also consider trying our export-specific tools: Exportizer Pro or Exportizer Enterprise. These are extremely cheap but very fast and highly customizable database export solutions which can open tens of database types and support tens of target formats.