Multi-DB
Querier is a 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 data, the data
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. |