Database Tour description
A universal database tool with integrated report builder

Database Tour Pro is a database utility with features like report builder , database tour.

Database Tour is a convenient and powerful database program, which includes different db utilities and tools like SQL tool, reporting tool, data converting, exporting, importing utilities and much more.

Database Tour works with data through the Borland Database Engine (BDE) or Microsoft ActiveX Data Objects (ADO). This allows using the program as a cross-database tool. So, to use Database Tour you need to install BDE 5.0 or above or ADO 2.1 or above.

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 About... section.

Database Tour developed mainly for professionals. But unexperienced users sometimes can use it also (e.g., for report printing, table editing and so on).

Database Tour's main purposes: accessing databases; convenience in viewing and editing data; automation of the most often used database operations; printing data in the most convenient view.

Database Tour is a cross-database tool. It 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). Access via ADO (using ODBC driver) or BDE (using DSN-based BDE alias or native driver (only Access 95-97)).
· Microsoft Excel (*.xls). Access via BDE (using DSN-based BDE alias) or ADO (using ODBC or ISAM 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).

Theoretically, Database Tour can work with some other formats (depending on database engine (ADO or BDE) installed).

Here are some key features of "Database Tour":

· Creating tables for different types of databases.
· Viewing, editing, and printing data from databases.
· Built-in report engine, which allows to produce the reports automatically or by using a visual report designer with templates, expressions, preview etc.
· Building and executing SQL queries. SQL syntax highlighting.
· Enhanced database grids, which allow to view and manipulate the data in the most convenient way.
· Creating, deleting, modifying BDE aliases.
· Command line support (for executing queries, opening tables, export-import operations, loading reports etc.).
· Searching and replacing text in database.
· Import data to table from another table or a query.
· Export data from open table of any format to text, HTML, Excel, XML, RTF and to databases of other formats (which supported by database engine installed).
· Copying data to clipboard.
· Calculating numeric fields (sum, avg, min, max, count).
· Viewing and editing Blob data, such as MEMO, graphic, RTF.
· Tools for editing text fields (trimming, changing case of symbols).
· Sorting (logical and physical) data.
· Filtering data.
· Viewing table and database structure with ability to print, copy, sort it.
· Reindexing tables.
· Customized data view (font, background). Conditional formatting data.
· Ability to control transactions manually.
· Storing database and SQL history
· Integrated report engine and report builder.
· Full command line support. While Database Tour supports only several command line options (for encrypting/decrypting files, direct opening files, and some auxiliary options like /ado, /bde etc.), the Database Tour Pro supports tens of command line options, including options for export operations, query executing etc.
· Generating SQL.
· Exporting SQL history to HTML and RTF.


Limitations:

· 24 days trial