Database Tour and Database Tour Pro are cross-database tools with large set of db tools and utilities like SQL tool, reporting tool, data converting, exporting, importing utilities and much more.
accessing different types of databases (for example, dBase, Paradox, text, CSV, Interbase, Firebird, Microsoft Access, Microsoft Excel, Oracle, SQL Server etc.);
convenient viewing and editing data;
using SQL with support of multi-statement scripts;
exporting data from open table or query to large number of file formats like text, CSV, HTML, XLS, XML, RTF, DBF, or to any of supported database formats;
automation of the most often used database operations like export and import, query execution etc.;
command line support with very large number of switches and parameters;
different ways of printing data.
New export modes for Database target format: UPDATE, APPEND+UPDATE, and DELETE.
New export option for Database target format: Use SQL parameters. It works with memory saving mode and allows to export BLOB fields and can significantly improve the export performance for some database types.
New command line parameters for exporting to Database target format: /KeyFields, /UseSQLParameters (Pro version only).
For Interbase interface, it is now acceptable to specify the database name in : format.
Include MEMO Fields export option will no longer be used for Database and dBase target formats. Including or not including certain fields for exporting can be controlled by Field Mappings options.