Database Tour

This software provides a set of tools that are useful for moving around in a range of databases, hence the name.

Database Tour is a cross-database tool. It works via ADO or BDE to get access into databases that can be as diverse as Paradox, dBase, FoxPro, ASCII, CSV, Interbase, Firebird, Lotus, HTML, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL and MySQL. Creating tables in any of these databases is possible. Complementary functions of viewing and editing of the data in these tables is also easily done. If you needed help with SQL queries, the same is available in the form of building and executing of SQL queries, execute multiple statements in the form of scripts and so on. The SQL editor that lets you create and edit these scripts helps things along by being syntax specific and can highlight the syntactical problems directly. It will support parameterized SQL building too.

Import and export of data in several formats are supported. These include text, CSV, HTML, XLS, XML, RTF, DBF or to any of supported database formats. Import of data from another table or through a query. Importing of data can be filtered according to the criteria you choose. You can copy data via the clipboard too. Several calculations, such as sum, avg, min, max, count can be carried out by the program. The diverse set of features also include viewing and editing capability of BLOB data, MEMO, graphic and RTF data; searching and replace of text with choice of fields to search and the records etc. If you needed to understand the structure of the database, just get the schema printed, copied or simply sort it. It will let you print data in several ways and you could have conditional formatting of data in database grids and reports. A customized view is possible too. Those of you who toil at keeping the databases straight at your organization would appreciate the value of this tool easily!

Database Tour is a cross-database tool. It works via ADO or BDE and was tested on Paradox, dBase, FoxPro, ASCII, CSV, Interbase, Firebird, Lotus, HTML, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL.
Key features:
-Accessing different types of databases.
-Creating tables.
-Viewing and editing data.
-Several ways to print data.
-Building and executing SQL queries.
-Support for execution of multi statement SQL scripts.
-Syntax highlighting in SQL editor.
-Support for parameterized SQL queries.
-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.
-Creating, deleting, modifying BDE aliases.
-Searching and replacing text in database with ability to choose fields, record range etc.
-Importing data to 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.
-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, replacing text).
-Sorting data.
-Filtering data according to user's criteria.
-Viewing table and database structure with ability to print, copy, sort it.
-Reindexing tables.
-Customized data view (font, background).
-Conditional formatting data in database grids and reports.
-Ability to control transactions manually.
-Storing database and SQL history.