Multi-Functional Database Tool

Here are some areas where Database Tour has competitive advantages among database tools in the marketplace.

Different Database Formats

Support for all major database types like ODBC, SQL Server, Access, Oracle, PostgreSQL, SQLite, Firebird, Interbase, Excel, Visual FoxPro, dBase, Paradox, CSV, MySQL, DB2, SQL Anywhere etc.

Powerful Data Export Capabilities

• Highly customizable export output to Excel, HTML, SQL script, DBF, CSV, and more.
• Copying data from database to database, for example, SQLite to Firebird, PostgreSQL to Oracle, Interbase to SQL Server etc.
• Convenient interface for mapping tables and fields between data sources and target objects.
• Data exporting templates. Ability to save export definitions to files in order to reuse them, which is extremely useful for complex data export tasks.
• Automating data export jobs using command line and action files.

SQL Query Tool

• SQL editors with syntax highlighting, code completion, and Ctrl+clickable objects.
• Multiple SQL query windows with separate transactions. Navigating through the query history and collecting SQL execution statistics for each database query window.
• Support for database query parameters and macros.
• Possibility to execute multi-statement SQL scripts.
• Generating SQL code for specific tasks.

Embedded Report Tool

Powerful report builder simplifies creating and editing your database reports. (Available in Pro version)

Big Set of Database Functions

Performing useful operations with databases, such as searching and replacing text, batch data processing, working with database objects etc.

Convenient Data View

Database Tour data grids give you the ability to view CLOB/MEMO (large text) and graphic data, expand rows, use autoscrolling, sorting, selecting group of records, copying data etc. Data in tables can be highlighted depending on its content (so called conditional formatting). There is a tool for working with BLOB fields, such as large text and graphics.

Command Line Support

Many database operations can be performed from the command line (mostly in Pro version). This allows executing them from batch files, schedulers, and in calls from other applications.