| Description Version
details Downloads How to buy Database
SQL tool, which allows running the same SQL queries on multiple databases
with similar structure at once. Can be used also for a single database as query
and export tool. If running query returns resulting table, it can be exported
to file of specified format. The tables from different databases can be either
consolidated in one file or the result for each database can be exported to separate
file. Possible output formats: Text (TXT), comma-separated values (CSV), dBase
(DBF), XML, HTML, RTF, Microsoft Excel (XLS). The program can work with
databases via BDE or ADO. It was tested on databases of the following types: Oracle
(via BDE and ADO), Interbase (via BDE), Paradox (via BDE), Microsoft Access (via
ADO) and dBase (via BDE and ADO). Theoretically, it can work also with other database
types, supported by these two database engines.
Connection parameters
for each database are stored in the file of internal format, so if they are specified
once, then there is no need to provide them again. The names of the most
recently used SQL files are also stored. The program can run multi-statement
scripts. Each statement must be separated by SQL terminating character or string,
which is specified by the user. SQL queries are edited in convenient SQL
editor with syntax highlighting. The most important operations can be performed
also via command line. |