Database Tour Pro is a database tool with built-in report builder. It works with relational databases like Oracle, PostgreSQL, Interbase, Firebird, SQL Server, MySQL, SQLite, Access, Excel, Visual FoxPro, dBase, Paradox, CSV, HTML etc.
Key features:
-Accessing different types of databases.
-Creating tables.
-Viewing and editing data.
-Several ways to print data.
-Built-in report engine and visual report designer with templates, expressions, preview etc.
-Expression builder for report and export expressions. -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.
-Command line support for executing queries, opening tables, export-import operations, loading reports etc. with logging the performed operations.
-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 file(s) like text, CSV, HTML, XLSX, XML, RTF, DBF or to another relational database. -Copying data to clipboard.
-Calculating numeric fields (sum, avg, min, max, count). -Viewing and editing Blob data, such as large text and graphics.
-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.
-Storing database and SQL history.
.jpg){kind=logo}
