Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Andrey Bistriy: "In our daily business we face the database management and refactoring. We were pleasantly surprised to discover SQL Maestro. After trying it out we started to use it on a regular basis".
Stephen Arrowel, Database Administrator: "We are in the process of implementing Firebird solutions at multiple levels in our international organization. We expect that SQL Maestro Group will do nothing short of revolutionize the way we develop and maintain our Firebird databases. The continuous improvement and development means that the product is extremely flexible and will grow with us. The service and responsiveness of the Support Team has been exceptional. They have devoted countless hours to understanding our needs, so that we could get a Firebird administration tool which would be so simple and effective in use. SQL Maestro Group is helping Sytrax sail into the 21st Century".

More

Add your opinion

Firebird Maestro online Help

Prev Return to chapter overview Next

Database Explorer

Database Explorer is the basic feature of Firebird Maestro which allows you to perform practically all necessary operations upon databases and their objects. The Database Explorer area occupies the left side of the Firebird Maestro main window. All the objects at the Explorer tree are grouped by kind and listed under the according Firebird servers/database node.

 

To start working with a database you need to create its profile first. The conception of database profiles gives you an opportunity to connect to databases in one touch and work with the selected databases only.

 

See also: Object Manager, Object Browser

 

Note: In case your databases have a large quantity of objects you can speed up the object search by typing first letters of the object name in the explorer area.

 

Note: Explorer options allow you to hide/display table subobjects, represent system objects in different color, etc.

 

The sections below describe each of these actions in detail.
 

 

 

 

Operations upon database profiles in the Explorer Tree

Using popup menu of the Explorer area you can realize the following operations:

 

create new database profiles (the Create Database Profiles... item);
rename currently selected database profile (the Rename Database Profile... item);
edit currently selected database profile (the Edit Database Profile... item);
reorder existing database profiles (the Reorder Databases...item of Databases node's popup menu or using drag-n-drop);
reorder servers (the Reorder Servers...item of a server's popup menu);
remove currently selected database profile from the explorer tree (the Remove Database Profile item);
remove all profiles of selected server (the Remove all Profiles item of Databases node's popup menu).

 

In addition to these operations, Database Explorer gives you an ability to reorder existing profiles by performing drag-and-drop operations within the explorer tree.

 

 

How can I connect to a database?

You can establish connection to a database in Database Explorer by selecting the database profile and double-clicking it or pressing the Enter key (alternatively, you may use the Shift+Ctrl+C hot key combination). The same operation is also available through the Connect to Database item from the explorer popup menu, or through the Database | Connect to Database main menu item.

 

Note: the number of expected server connections is from 1 to 1024.

 

 

How can I disconnect from a database?

You can abort connection from a database in Database Explorer by selecting the database profile and pressing the Shift+Ctrl+D hot key combination. The same operation is also available through the Disconnect from Database item from the explorer popup menu, or through the Database | Disconnect from Database main menu item.

 

 

Operations upon database objects

Database Explorer allows you to perform the following operations with database objects using its popup menu (note that the popup menu contains object-specific items only when some database object is currently selected in the explorer tree):

 

create a new database object (the Create New Object... item);
edit currently selected database object (using the Edit Object... item, pressing the Enter key or double-clicking the database object);
drop the selected object from the database (the Drop Object... item);
rename the selected database object (the Rename Object... item);
edit the database object properties (the Object properties ... item);
duplicate the selected object (the Duplicate Object... item).
run the Object Browser tool (the Browse ... item).

 

 

Can I copy a database object from one database to another?

Database Explorer provides you with an ability of copying database objects from one database to another. To perform this operation, you should connect to both the source and the destination databases first. After the connection is established, simply drag and drop an object to copy from the source database to the corresponding node (Tables, Queries, etc.) of the destination database.

 

Note: You also can use the Edit | Copy and the Edit | Paste main menu items to copy/paste a database object using Windows clipboard (alternatively, you may use the Ctrl+C/Ctrl+V hot keys combinations respectively).

 

 

How can I create new/drop a database?

To create a new Firebird database (not existing on your Firebird server) with Database Explorer, select the Create New Database... item from the popup menu and set all the necessary options within the Create Database Wizard.

 

To drop an existing database using Database Explorer, connect to the database you wish to drop, select the Drop Database item from the popup menu of the database and confirm dropping in the dialog window.

 

Note: Alternatively, you can use the Database | Create New (Drop) Database main menu item to perform these operations.



Prev Return to chapter overview Next