Database Tour is a cross-database tools with large set of db tools and utilities like SQL tool, reporting tool, data converting, exporting, importing utilities and much more.Every open table or query can be exported to the new table or file. The format conversion is also possible. Except the standard database formats, the data can be exported to the text, RTF or HTML documents, Excel sheets and some other formats. There is a set of options, which gives an ability to maximally customize the exporting. Exporting to HTML and RTF can be performed with pictures and all text formatting (including conditional formatting). Field mappings for export and import can be saved to file and loaded from file. It is possible to use calculated fields.Data exporting can also be executed in command line mode (Database Tour Pro only). This allows to use the feature in scheduling and in making calls to Database Tour Pro from other programs, including your own ones.
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 RTF formats. It can also convert image format on the fly. Exporting 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. Exporting Several Tables to One File:
In just a few clicks you can easily export several selected tables to one target file. Exporting selected tables as one table per file is also possible. Exporting with Formatting:
When exporting a current dataset to HTML, it is possible to preserve current formatting (font and background) of the table columns. 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. Exporting to Database:
You can export data not only to many file formats, but also to any relational database, supported by ADO, BDE, or Interbase interface. Field Mappings:
You can specify source-to-target field mappings before exporting data. Importing data:
The program allows to import data into the current database from another table (including other database) or open query. There are lot of useful import options.