Database Tour Pro 11.5.12.713

Database Tour Pro 11.5.12.713

Database Tour Pro is a comprehensive software application that enables you to organize all your connected databases. It offers support for Borland Database Engine (BDE) and Microsoft ActiveX Data Objects (ADO), SQL scripts, reports, along with data conversion and exporting, among others.

Outdated, yet clear-cut interface
Wrapped up in a large window with a well-structured layout, the interface seems outdated. It contains an object browser for functions, packages, triggers, directories, users, roles, profiles, sequences, jobs, types, Java, exceptions, database links, general properties, tables, schemas, and procedures.

Manage tables and queries
Tables can be created, deleted, emptied, duplicated, renamed or packed. You can allow table editing, view deleted records, set a table password, change the language driver, add, remove, rename and resize fields, add, delete or regenerate indexes, check out the table family, as well as verify referential integrity.
When it comes to queries, Database Tour Pro lets you save, load and print SQL scripts or history, and explore a wide range of predefined query templates which can be seamlessly inserted into the project, like select, update, insert and delete, add or drop field, and create view or create table.

Encrypt databases and build reports
It’s possible to isolate, start, commit and roll back transactions, review the database history, clear the password list, resort to a search-and-replace function, as well as locate objects and fields.
The software utility puts a bunch of useful tools at your disposal, including arithmetic functions, batch operations with text fields, a report builder and previewer, printer for table data, data importer and exporter, file encryption and decryption, in addition to a command-line generator.

Features

• Accessing different types of databases.
• Creating tables.
• Viewing data.
• Editing data.
• Several ways to print data.
• Built-in report engine, which allows to produce the reports automatically or by using a visual report designer with templates, expressions, preview etc.
• Expression builder for report 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.
• Creating, deleting, modifying BDE aliases.
• 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 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 (logical and physical) 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.