Online Documentation for SQL Manager for InterBase/Firebird

Database Tools

SQL Manager for InterBase/Firebird provides graphical interface for a number of database maintenance operations. The following services are available in SQL Manager:

 

Dependency Tree

Allows you to view all the object dependencies in one diagram.

 

SQL Monitor

Displays all the SQL statements executed while working in SQL Manager for InterBase/Firebird.

 

Execute Script Editor

Executes SQL scripts in the database.

 

Extract Database Wizard

Extracts the table metadata and/or data to an SQL script which can be executed later on another machine to restore the database structure and/or data.

 

Compare Databases

Compares databases metedata and generates SQL script which can be executed later on another machine to synchronize the databases structure.

 

Print Metadata

Creates powerful metadata reports in the WYSIWYG mode ready for printing.

 

HTML Report

Creates powerful metadata reports in the HTML format.

 

Reports management

Tools for efficient management of reports: creating, editing, viewing, printing.

 

Search in Metadata

Provides quick search for a string within the scope of database metadata.

 

Database Monitor

Displays various statistics on database in general and database activities.

 

Event monitor

Allows you to view event notifications.

 

Table Altering Monitor

Allows you to view the number of changes in table and view metadata.

 

Server Messages Editor

Allows you to view and edit server messages.

 

Database Designer

Allows you to lay out your database schema visually.

 

Using templates

Facilitates using SQL Manager wizards.

 

---