Multi-DB Querier 1.2
Multi-DB Querier description
Multi-DB Querier allows running the same SQL queries on multiple databases with similar structure at once.
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.
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.
Other software by Vitaliy Levchenko
- Database Tour 5.2.0.745-Universal database tool
- Reportizer 2.4-Database reporting tool
- Icons from file 3.3-Extracts icons or icon arrays from files (EXE, DLL, OCX, etc.)
- Exportizer 3.7-Exports database to clipboard or file
- Exportizer Pro 3.7-Exports database to clipboard or file
[More
software from Vitaliy Levchenko]
related software to Multi-DB Querier
- Exportizer Exports database to clipboard or file
- Database Tour Universal database tool
- PostgreSQLDirect .NET An enhanced data provider for PostgreSQL-based database applications development
- SQLDirect .NET An enhanced data provider for SQLServer-based database applications development.
- MyDirect .NET An enhanced data provider for MySQL-based database applications development.
- MyDeveloper Studio Database development and administration environment for MySQL
- EMS SQL Manager for DB2 State-of-the-art GUI tool for DB2 Server administration and development.
- EMS SQL Manager for DB2 Freeware State-of-the-art GUI tool for DB2 Server administration and development.
Most popular software

