Using the Server Manager

Previous  Index  Next  How To Use

The Server 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:

Server Manager for InterBase
Server Manager for Firebird
Server Manager for MS SQL Server
Server Manager for MySQL
Server Manager for Oracle
Server Manager for NexusDB
Server Manager for PostgreSQL
Server Manager for SQLite

 

Toolbar

The Server 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

 

Server 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 Server 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.