Database Tour 5.8.7.1319

Database Tour 5.8.7.1319 is a cross-database tool which is tested on Paradox, dBase, FoxPro, ASCII, Lotus, HTML, InterBase, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL.

Major Features:

1. Creating tables for different types of databases.
2. Viewing data in databases.
3. Editing data.
4. Several ways to print data.
5. Built-in report engine, which allows to produce the reports automatically or by using a visual report designer with templates, expressions, preview etc.
6. Expression builder for report expressions.
7. Building and executing SQL queries.
8. Support for execution of multi statement SQL scripts.
9. Syntax highlighting in SQL editor.
10. Support for parameterized SQL queries.
11. 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.
12. Creating, deleting, modifying BDE aliases.
13. Command line support for executing queries, opening tables, export-import operations, loading reports etc. with logging the performed operations.
14. Searching and replacing text in database with ability to choose fields, record range etc.
15. Import data to table from another table or a query.
16. Export data from open table or query of any format to text, HTML, XLS, XML, RTF, CSV and to databases of other formats (which supported by database engine installed).
17. Copying data to clipboard.
18. Calculating numeric fields (sum, avg, min, max, count).
19. Viewing and editing Blob data, such as MEMO, graphic, RTF.
20. Tools for editing text fields (trimming, changing case of symbols).
21. Sorting (logical and physical) data.
22. Filtering data according to specified criteria.
23. Viewing table and database structure with ability to print, copy, sort it.
24. Reindexing tables.
25. Customized data view (font, background).
26. Conditional formatting data in database grids and reports.
27. Ability to control transactions manually.
28. Storing database and SQL history.

Enhancements:

• Export improvement;
• Minor changes in SQL editor.