Database management
SQL Manager 2008 for InterBase/Firebird provides a number of tools you may need to manage your InterBase/Firebird databases.
Find the list of common database management operations for working in SQL Manager below.
In order to register a Host in SQL Manager 2008 for InterBase/Firebird:
-
select the Database | Register Host... main menu item or use the corresponding Register Host
toolbar button
or
- right-click the Host and select the Register Host... context menu item in the DB Explorer tree;
- set all the necessary options using Register Host wizard which guides you through the entire process of Host registration.
In order to unregister a Host in SQL Manager 2008 for InterBase/Firebird:
- select the Host to unregister in the DB Explorer tree;
-
select the Database | Unregister Host main menu item or use the corresponding Unregister Host
toolbar button
or
- right-click the Host and select the Unregister Host context menu item in the DB Explorer tree;
- confirm unregistering in the corresponding dialog window.
Viewing and editing Server Properties
In order to view/edit Server properties in SQL Manager 2008 for InterBase/Firebird:
- select the host or a database that resides on this host in the DB Explorer tree;
- right-click the host or the database alias and select the Server Properties context menu item.
In order to create a Database in SQL Manager 2008 for InterBase/Firebird:
-
select the Database | Create Database main menu item or use the corresponding Create Database
toolbar button;
- set all the necessary options using Create Database wizard which guides you through the entire process of creating a new database.
In order to drop a Database in SQL Manager 2008 for InterBase/Firebird:
- select the Database to drop in the DB Explorer tree;
- select the Database | Drop Database main menu item;
- confirm dropping in the corresponding dialog window.
In order to register a single Database in SQL Manager 2008 for InterBase/Firebird:
-
select the Database | Register Database... main menu item or use the corresponding Register Database
toolbar button
or
- right-click the Database and select the Register Database... context menu item in the DB Explorer tree;
- set all the necessary options using Register Database wizard which guides you through the entire process of Database registration.
In order to unregister a Database in SQL Manager 2008 for InterBase/Firebird:
- select the Database to unregister in the DB Explorer tree;
-
select the Database | Unregister Database main menu item or use the corresponding Unregister Database
toolbar button
or
- right-click the Database and select the Unregister Database context menu item in the DB Explorer tree;
- confirm unregistering in the corresponding dialog window.
In order to connect to a Database in SQL Manager 2008 for InterBase/Firebird:
- select the Database to connect to in the DB Explorer tree;
-
select the Database | Connect to Database main menu item or use the corresponding Connect to Database
toolbar button
or
- right-click the Database and select the Connect to Database context menu item in the DB Explorer tree.
In order to disconnect from a Database in SQL Manager 2008 for InterBase/Firebird:
- select the Database to disconnect from in the DB Explorer tree;
-
select the Database | Disconnect from Database main menu item or use the corresponding Disconnect from Database
toolbar button
or
- right-click the Database and select the Disconnect from Database context menu item in the DB Explorer tree.
Viewing and editing Database Registration Info
In order to view/edit Database Registration Info in SQL Manager 2008 for InterBase/Firebird:
- select the Database or any of its objects in the DB Explorer tree;
- select the Database | Database Registration Info... main menu item
or
- right-click the Database or any of its objects and select the Database Registration Info... context menu item in the DB Explorer tree.
Viewing and editing Database Properties
In order to view/edit Database properties in SQL Manager 2008 for InterBase/Firebird:
- select the Database in the DB Explorer tree;
-
right-click the Database and select the Database Properties... context menu item or use the corresponding Properties
toolbar button
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
Yes |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
