Database Tour is available in two editions: Standard (Database Tour) and Professional (Database Tour Pro). The following table shows what features are available in each edition.
Feature comparison | ||
Feature | Standard Edition (Database Tour) | Pro Edition (Database Tour Pro) |
Accessing different types of databases | ||
Table browsing | ||
Editing data | ||
Searching and replacing text in database with ability to choose fields, record range etc. | ||
Importing data to a table from another table or a SQL query result | ||
Exporting data from open table or query to large number of file formats like text, CSV, HTML, JSON, XLS, XLSX, XML, RTF, DBF or to any of supported database formats | ||
Duplicating tables and other database objects | ||
Basic command line support | ||
Enhanced command line support: executing database queries, opening tables, export and import operations, loading reports etc. with logging the performed operations | ||
Using action files | ||
Basic printing data | ||
Enhanced printing abilities: built-in report engine, which allows to produce the reports automatically or by using a visual report designer with templates, expressions, preview, conditional formatting etc. | ||
Creating tables | ||
Building and executing SQL queries | ||
Support for execution of multi-statement SQL scripts | ||
Syntax highlighting in SQL editor | ||
Support for parameterized SQL queries | ||
Storing database and SQL history | ||
Enhanced database grids, which allow to view and manipulate the data in the most convenient way, including sorting by clicking column header, changing row heights, resizing columns etc. | ||
Copying data to clipboard | ||
Calculating numeric fields (sum, avg, min, max, count) | ||
Viewing and editing Blob data, such as MEMO, CLOB, graphic, RTF | ||
Batch editing text fields (trimming, changing case of symbols, replacing text) | ||
Sorting (logical and physical) data | ||
Filtering data according to user's criteria | ||
Viewing table and database structure with ability to print, copy, and save it | ||
Reindexing tables | ||
Customized data view (font, background) | ||
Conditional formatting data | ||
Ability to control transactions manually | ||
Creating, deleting, modifying BDE aliases |