MiTeC Interbase Query

A must-have tool for every Interbase/Firebird administrator or developer

Description

This tool provides complete management of any Interbase 6+/Firebird 1.5+ database. It is based on IBX components.

It contains following modules:

SQL Editor
It contains SQL Editor with syntax highlighting with Result Buffer. You can run any type of sql statement or script. Output is flushed to formatted text, not to grid, what it allows more flexible and synoptic result overview.
SQL History
Every correctly run statement is saved in SQL History Buffer. You can open multiple instances of this editor to run “simultaneous” queries.
Object Explorer
Here you can inspect every database object including its detail properties. Some object you can edit too. Also you can extract metadata of all objects including data for tables.
User Manager
Allows you add, edit and delete database users and roles.
Grant Manager
Allows to grant or revoke privileges on all database objects.
Services
Here are available following services:
- Server Log View
- Server Properties Overview
- Database Statistics Overview
- Database Validation Task
- Database Shutdown
- Database Online

Registered version contans in addition also:

Data Import/Export
You can also export/import data to/from CSV, XML, raw batch file or printer.
Index Rebuilder
This tools allows to select and rebuild all non-system indices and display their statistics.
Event Watcher
Here you can inspect user defined event triggering.
Performance Monitor
This tool allows profile and watch database operations. It contains following modules:
- Memory usage of watched database
- Number of writes and read to database and to buffer cache
Codebase
Allows to save and reuse often used statements or scripts.