Database Tour Pro is a powerful tool for managing and organizing databases efficiently. It supports popular database engines like Borland Database Engine (BDE) and Microsoft ActiveX Data Objects (ADO), making it easy to connect and work with different database formats. With its user-friendly interface, you can write SQL queries, generate reports, and convert or export data smoothly. Whether you are a beginner or an advanced user, this software simplifies complex tasks. Ideal for developers, IT professionals, and database administrators, Database Tour Pro helps you streamline your workflow. Download it today from our website and unlock a better way to manage your databases on Windows!
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 of Database Tour Pro
– 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.
Developer: Homepage
Requirements: Windows
License: Shareware
Language: Multilingual