Database Tour Pro is a universal database tool. It works with all major types of databases like dBase, Microsoft Access, Microsoft Excel, Oracle, SQL Server, SQLite, PostgreSQL, Paradox, text, CSV, Interbase, Firebird.
Data can be viewed and edited in convenient database grids with ability to work with specific data types like BLOB, large text. Its SQL tool supports execution of multi-statement scripts. There is a powerful export tool which exports data to large number of file formats like text, CSV, JSON, HTML, XLSX, XLS, XML, RTF, PDF, DBF, SLK, SQL Script or to any of supported database formats; for example, you can convert Access to SQL Server, Interbase to Oracle, CSV to PostgreSQL.
This db tool also includes a command line interface which allows to automate the most important database operations like SQL query execution, data exporting.
What is new in this release:
Version 9.4.7.20:
- Minor improvements and bug fixes when working with Oracle, PostgreSQL, and Firebird databases.
- Minor improvements in BLOB Editor.
What is new in version 9.2.1.88:
Version 9.2.1.88:
- Exporting BLOBs and CLOBs into individual files.
- Export to text and Excel (xlsx) corrections.
- Improvements in export field and table mappings setup.
What is new in version 9.1.9.23:
Version 9.1.9.23:
- Ability to create new SQLite databases.
- Improvements in interface when working with SQLite databases.
- Minor bugfixes.
What is new in version 9.1.5.55:
Version 9.1.5.55:
- Improvements in exporting to databases by ADO means.
- Minor changes and bug fixes.
What is new in version 9.0.8.18:
Version 9.0.8.18:
- Functions dataset_field_val, dataset_field_is_null, dataset_nvl can now accept a field index instead of the field name as second parameter.
- Minor changes and bugfixes.
What is new in version 9.0.4.54:
Version 9.0.4.54:
- Improvements in SQL windows.
- Improvements for SQL Server databases.
What is new in version 8.3.0.23:
Version 8.3.0.23:
- Creating schemas for Unicode text and CSV files.
- Using different encodings when exporting to text or CSV.
What is new in version 8.2.9.16:
Version 8.2.9.16:
- Minor changes.
What is new in version 8.2.8.23:
Version 8.2.8.23:
- Minor bugfixes.
What is new in version 8.2.7.39:
Version 8.2.7.39:
- Multiple tables can be exported to one XLSX file, one table per sheet.
- Multiple table tables can be exported to one SQL file.
What is new in version 8.2.5.21:
Version 8.2.5.21:
- Minor changes.
What is new in version 8.2.3.45:
Version 8.2.3.45:
- Improved source-to-target field type mapping for Database and SQL Script target formats.
- Extended format of field mappings file.
- In Export dialog, Field Mappings section, it is now possible to view the target columns SQL specifications for Database target format.
- In Export dialog, Field Mappings and Table Mappings sections, added utilities to change the case of characters in the target names.
- New functions for batch operations with text fields: Add Prefix, Add Suffix.
- New command line options for batch operations with text fields: /AddPrefix, /AddSuffix.
What is new in version 8.1.9.20:
Version 8.1.9.20:
- Minor GUI changes.
- Minor changes in report engine.
What is new in version 8.1.8.29:
Version 8.1.8.29:
- When exporting to SQL script, it is now possible to use COPY command for PostgreSQL target database.
- Ability to use Mac styled line breaks for text export formats.
- GUI improvements.
- Minor changes.
What is new in version 8.1.6.11:
Version 8.1.6.11:
- Possibility to create blank Microsoft Access databases (.mdb).
What is new in version 8.1.5.14:
Version 8.1.5.14:
- Improvements in exporting to SQL Script and PosgreSQL.
- Minor changes.
What is new in version 8.1.2.27:
Version 8.1.2.27:
- Improvements for working with PostgreSQL, Oracle, SQL Server, Interbase databases.
What is new in version 8.1.1.9:
Version 8.1.1.9:
- Minor improvements in GUI.
What is new in version 8.1.0.45:
Version 8.1.0.45:
- Exporting data to XLSX.
- Export speed increased up to 2 times for most of export formats.
- Exporting reports to XLSX.
What is new in version 8.0.8.4:
Version 8.0.8.4:
- Minor changes in exporting to SQL Script for SQL Server.
- Bugs fixed in exporting to PDF.
What is new in version 8.0.7.25:
Version 8.0.7.25 may include unspecified updates, enhancements, or bug fixes.
What is new in version 8.0.6.12:
Version 8.0.6.12:
- Expression engine optimization.
- Ability to change report object names in report designer without needing to do it in the report text.
- All db functions in report expressions can now be used in double-pass mode.
- Minor improvements and bug fixes in report designer.
What is new in version 8.0.5.25:
Version 8.0.5.25:
- New export formats: SYLK, Excel (OLE), Word (OLE).
- Ability to work with favorite export formats only.
- Minor changes in export to PostgreSQL.
- Minor bug fixes in report designer.
What is new in version 8.0.4.19:
Version 8.0.4.19:
- Minor changes in export procedures.
- Minor changes in data grids.
What is new in version 8.0.1.21:
- Multi-column sorting in file reports.
- Fixed filtering problems in file reports.
- Minor bugfixes in export routines.
What is new in version 8.0.0.123:
- New report expression engine.
- Redesigned Expression Builder.
- Improved sorting capabilities in grids.
- Overall interface improvements.
What is new in version 7.2.5.1291:
- Minor changes in exporting to HTML and RTF.
- New expression engine functions to use in dynamically calculated expressions.
What is new in version 7.2.3.1169:
- Better processing SQL Server Compact (SDF) files.
- New export option for multi-table HTML export: Create index file.
- Several minor export related bugs fixed.
What is new in version 7.2.0.1012:
Version 7.2.0.1012:
- Several new expression engine functions which can be used in HTML templates.
- Minor fixes in Help topics describing expression engine functions.
- Redesigned Export dialog.
What is new in version 7.1.7.870:
- Minor changes in exporting to SQL Script.
- Improvements in Report Builder window.
- Minor changes in report engine.
What is new in version 7.1.6.834:
- Improvement of copy/paste functionality in database grids: 1) Minor display errors fixed. 2) Now, pasting cells from clipboard using Ctrl+Alt+V can be done in Update+Insert mode, i.e. updating existing cells and inserting new cells if cell range in clipboard beyonds last record in target table.
- Added support for renaming columns via GUI in MySQL, Interbase, Firebird, and Microsoft Access databases.
- Optimized 'Use SQL parameters' export option for several database types.
- Minor bugfixes in SQL editors and some system checks.
What is new in version 7.1.5.798:
- Ability select an arbitrary range of cells in database grid by mouse and then copy them to clipboard using Ctrl+C combination.
- Ability to copy graphic data directly from database grid using Ctrl+C combination.
- Minor changes in export GUI.
What is new in version 7.1.3.738:
- New export modes for Database target format: UPDATE, APPEND+UPDATE, and DELETE.
- New export option for Database target format: Use SQL parameters. It works with memory saving mode and allows to export BLOB fields and can significantly improve the export performance for some database types.
- New command line parameters for exporting to Database target format: /KeyFields, /UseSQLParameters.
- For Interbase interface, it is now acceptable to specify the database name in : format.
- Minor changes.
What is new in version 7.1.2.677:
- New export options for SQL Script target format: ability to produce not only INSERT statements, but also UPDATE, MERGE, and DELETE ones.
- New command line parameters for export to SQL Script: /SQLStatementType and /KeyFields.
- Minor changes.
Requirements:
Microsoft ADO 2.1+, Borland Database Engine 5.0+, or Interbase 6+
Limitations:
24-day trial
Comments not found