| | | Key
features Special requirements
Supported database types
What
Database Tour features highlight it among other database tools?
Import
/ Export data Reports and data printing
Language support Installation
package
|
| Key
features |
| Feature |
Support in Standard Edition |
Support in Professional Edition |
| (Database Tour) |
(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 query |
 |
 |
| 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 |
 |
 |
| Duplicating tables and other database objects |
 |
 |
| Basic command line support |
 |
 |
| Enhanced command line support: executing queries,
opening tables, export and import operations, loading reports etc. with logging the
performed operations |
 |
 |
| 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 |
 |
 |
| Exporting
SQL history to HTML and RTF |
 |
 |
| 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, 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 |
 |
 |
| | to
top | | Special
requirements | |
Database Tour works on Windows 98/NT4/2000/ME/XP/2003/Vista/7.
To use Database Tour, you need ADO 2.1+ or BDE 5.0+.
ADO is included
in Windows 2000 and above. For other Windows systems, you may download and install
MDAC from Microsoft web site. You can check the presence of BDE and ADO on your
machine and their versions after installing Database Tour in its About... section. |
| to
top | | Supported
database types | |
Database Tour works with databases via ADO or BDE and was tested on the following
database types: - dBase / FoxPro (*.dbf). Access via BDE or
ADO (using ODBC or ISAM drivers).
- Paradox (*.db). Access via BDE
or ADO (using ODBC or ISAM drivers).
- Text (*.txt). Access via BDE
(text tables with schema files *.sch) or ADO (using ODBC or ISAM drivers).
- Comma
separated values (*.csv). Access via ADO (using text ODBC driver) or BDE (for
export purposes only).
- Lotus (*.wk1, *.wj2). Access via ADO (using
ISAM driver).
- HTML (*.htm, *.html). Access via ADO (using ISAM
driver).
- XML (*.xml). Access via BDE (for export purposes only)
or ADO (for import / export operations only).
- Interbase (*.gdb).
Access via BDE (using direct file link for local databases or BDE aliases for
remote databases) or ADO (using ODBC driver with direct file link for local databases
or ODBC DSN for remote databases).
- Microsoft Access (*.mdb, *.accdb).
Access via ADO (using ODBC driver or Jet/ACE engine) or BDE (using DSN-based BDE
alias or native driver (only Access 95-97)).
- Microsoft Excel (*.xls,
*.xlsx, *.xlsb, *.xlsm). Access via BDE (using DSN-based BDE alias) or ADO (using
ODBC driver or Jet/ACE engine).
- Microsoft Visual FoxPro (*.dbc).
Access via BDE (using DSN-based BDE alias) or ADO (using ODBC drivers).
- Oracle.
Access via BDE (using BDE alias) or ADO (using ODBC DSN).
- SQL Server.
Access via BDE (using BDE alias) or ADO (using ODBC DSN).
- PostgreSQL.
Access via BDE (using DSN-based BDE alias) or ADO (using ODBC DSN).
- MySQL.
Access via BDE (using DSN-based BDE alias) or ADO (using ODBC DSN).
Database Tour can also work with any other database formats which support ODBC, ADO,
or BDE interface. |
| to
top |
|
What Database Tour features highlight it among other
database tools? | | 1. Integrated
report engine with a report designer (Database Tour Pro only). Data from any open
table or query can be printed in the most convenient view directly in Database
Tour Pro, without needing to transfer the data into other programs (although this
is also possible!). Database Tour Pro uses its own report engine. 2.
Export-import data (see topic below). 3. Running SQL dumps. With specifying
a separator for SQL statements, you can run dumps with unlimited count of statements
at a time. 4. Big set of functions, which perform most often used operations
with databases, such as searching and replacing text etc. 5. Great
convenience of viewing the data. Table components of Database Tour give you ability
to view MEMO and graphic fields, expand rows, use autoscrolling, sorting, selecting
group of records, copying data etc. Data in tables can be highlighted concerning
to its content (so called conditional formatting). There is a tool for working
with BLOB fields, such as MEMO, graphic, RTF. 6. Large number of operations
can be performed through command line (mostly in Database Tour Pro). This allows
using it in batch files, schedulers, and in calls from your own programs. See
more screenshots
| |
to top | |
Import / Export data |
| The program allows to import data into the opened table from
another table (which can be of other data format) or open query. There some useful
import options, such as field matching, import type (appending, updating or deletion),
specifying the buffer for error records etc. See
more screenshots
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 formating (including conditional formatting). Field mappings
for import/export can be saved to file and loaded from file. This gives additional
flexibility for these operations. 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. See
more screenshots
| | to
top | | Reports
and data printing | | Database
Tour can print the table data either as they shown in the data grid or by using
its own database reporting tool (Database Tour Pro only). Such data, as contents
of the graphic, Memo or RTF fields, can be printed either separately or in reports
(except RTF). In the first (after opening data set) accessing the report
builder or preview the report is automatically generated. In many cases it is
enough to print the data. If the automatically created report does not satisfy
the user, it can be edited in the report builder. Report builder allows to customize
your reports quickly and easily. It contains convenient object inspector, tool
bars etc. See
more screenshots
Database Tour Pro reports allow using the aggregated
expressions, grouping the data (only one level in the current version), paste
graphic shapes and pictures (from files or database), highlight text by colors,
background, borders etc. When the report is ready, its template can be saved
to file. It can be loaded from file every time when it is needed. The template
can be opened from the file either in the program (from report builder after opening
the data set) or simply by double-clicking the file in Windows Explorer (in this
case the linked data set is automatically opened and the report template is loaded
- you just print it!). See
more screenshots
| | to
top | | Language
support | | Current Database Tour
version supports the following interface languages: English, French, German, Italian,
Spanish, Polish, Ukrainian, Russian, Catalan. Help files already developed for
English and Ukrainian languages. Users can switch between the languages at any
time. | | to
top | | Installation
package | | - Main (executable)
file. - Help files with many different examples. - Sample databases in
DBF format. - Files with column definitions for the sample databases; just
open the database, right-click the data grid and choose Load Columns to load the
column definitions and understand how to customize the table view. - Example
of export results in HTML format. - Several report templates for sample databases
(can be used in Database Tour Pro only); just open the table, load the template
in report builder and choose Report Preview to view Database Tour reporting. |
| to top | |
Download
| | |
|