The Enterprise Manager does more than just listing the available servers and databases. It is your gateway to any server-specific task.
For example, with InterBase servers, you can double click the License Manager node to view, add and delete InterBase licenses. Or the User Manager node to view, add and delete InterBase user accounts.
Of course, the available options differ from server to server.
For more information on options per server type, use the following:
•Enterprise Manager for InterBase
•Enterprise Manager for Firebird
•Enterprise Manager for MS SQL Server
•Enterprise Manager for Oracle
•Enterprise Manager for NexusDB
•Enterprise Manager for Sybase Anywhere
•Enterprise Manager for PostgreSQL
The Enterprise Manager can be docked (default).
Toolbar
The Enterprise Manager toolbar has the following buttons:
1.Register Server
2.Duplicate Server Registration
3.Un-register Server
4.Create New Folder
5.Delete Folder
6.Create New Database
Enterprise Manager Toolbar
1.Register Server
This will open the Register Server Wizard.
2.Duplicate Server Registration
Allows you to copy a server registration, for example to test things with a different user name, or with SSL enabled or other connection properties.
3.Un-register Server
If you have not focused a server entry, the Select a Server dialog will be shown. Select a server from this dialog to un-register. If you un-register a server, all of the Database Workbench options related to this server will be gone.
Select a Server dialog
4.Create New Folder
You can group servers inside folders, creating a new folder and then drag the server into it, or edit the server registration properties and select the server from the drop down box.
Alternatively, when on the Databases node of a server, you can also group the databases into custom folders. The context menu shows this option as well.
5.Delete Folder
Delete an Enterprise Manager folder, either a folder for servers or a folder for grouping databases.
6.Create New Database
If you have not focused a server entry, the Select a Server dialog will be shown (see above). Once a server is selected, the Create Database wizard will be started. These are server-type specific, consult the Database Engine Specific Topics.