Wednesday, April 1, 2009

Database Tour Pro Manage your database with variety of functions!

For a software developer, a «Swiss knife»-style tool can be incredibly useful, but only when that?s the «right» tool. The problem is, nobody can tell you exactly, how to determine whether a tool is «right». A right tool must be full-featured, but it must not be overloaded with features; a right tool must have laconic and functional interface, but it must be easy to learn and understand; it must support all possible platforms, but must also be not bloated. In the database area, Database Tour Pro is the right Swiss-knife tool.

As for the platform aspect, Database Tour Pro supports virtually all databases, which can be accessed through BDE or ADO database abstraction layers. That includes a wide range, from the simple CSV files through the enterprise-level Oracle databases.

As for the features aspect, Database Tour Pro allows all of the standard database management tasks (creating tables, viewing, editing and printing data) alongside with the more advanced ones (import and export, copy to clipboard, syntax-highlighting SQL editor and builder.) It also provides complex features for data analysis, sorting, filtering and reporting. The software also works in command-line mode, which makes it a good tool for DB scripting.

As for the interface side, Database Tour Pro has colorful, informative and quite slick interface; it provides outstanding BLOB viewing capabilities (for images, RTF’s and so on).

Cross-database tool with report builder. Tested on Paradox, dBase, FoxPro, ASCII, Lotus, HTML, InterBase, Oracle, SQL Server, MS Access, MS Excel, PostgreSQL, MySQL.

Main features are:

-Viewing, editing, and printing data.

-Automatically created reports and convenient report builder (with templates, expressions, preview, etc.).

-Building queries with tools for convenient writing the SQL statesments.

-Enhanced db grids, which allow to view and manipulate the data in the most convenient way.

-Creating, deleting, modifying BDE aliases.

-Command line support for most important operations like exporting, query executing etc. Log of performed operations.

-Searching and replacing text.

-Importing data to table from another table or a query.

-Exporting data from any open table or query to another database or file (with format conversion).

-Copying data to clipboard.

-Calculating numeric fields (sum, avg, min, max, count).

-Editing BLOB fields (MEMO, graphic).

-Tools for editing string fields (trimming, changing case of symbols).

-Sorting (logical and physical) data.

-Filtering data.

-Viewing structure with ability to print it.

-Limited table restructure.

-Reindexing tables.

-Customized data view (color, font style, temporarily hiding any column).

-Transaction control.

More about Database Tour Pro