This software is a SQL database tool designed to perform queries on multiple databases with similar structures. SELECT query results can be exported in several file formats, and a command line feature is also available.
This software is an SQL tool that is designed for running SQL queries on multiple databases simultaneously. It works well on databases with similar structures and can also be used as a query and export tool for a single database.
Exporting Feature:
If the query generates a table, it can be easily exported to a file in a user-specified format. The software also allows consolidating tables from different databases into a single file or exporting the result for each database to a separate file. The possible output formats include Text (TXT), comma-separated values (CSV), dBase (DBF), XML, HTML, RTF, and Microsoft Excel (XLS).
Database Compatibility:
The program can work with databases via Borland Database Engine (BDE) or ActiveX Data Objects (ADO). It has been tested on various database types such as Oracle (via BDE and ADO), Interbase (via BDE), Paradox (via BDE), Microsoft Access (via ADO), and dBase (via BDE and ADO). It can also work with other database types that are supported by these two database engines.
User-Friendly Features:
The software stores connection parameters for each database in an internal file format, eliminating the need to specify them repeatedly. It also stores the names of the most recently used SQL files. The program has a convenient SQL editor with syntax highlighting for editing SQL queries. Multi-statement scripts can also be executed after separating each statement by an SQL terminating character or string specified by the user.
Command-Line Features:
Many of the most important operations can be performed via the command line. This makes using the software even easier for users who prefer this method.
Conclusion:
In summary, this SQL tool is a great solution for running queries on multiple databases with similar structures. It is also an excellent query and export tool for a single database. With its user-friendly features and compatibility with a wide range of databases, users can efficiently manage their data and easily export results in various file formats.
Version 1.51: Changes in SQL engine
Version 1.5: Improved SQL editor; improved export to DBF
Version 1.4: Saving the most recently used output file names; Minor changes and bugfixes
Version 1.31: Minor changes and bugfixes
Version 1.3: New options to improve performance
Version 1.2: New options and interface improvement
Version 1.12: Interface improvement
Version 1.11: Dragging SQL files into