Registering a Database
Previous  Top  Next

InterBase doesn't keep track of databases on the server machine, therefore you need to register databases that you want to use with Database Workbench.

You can do this by right clicking on the server or Databases node and selecting Register Database or by double clicking the Databases node.

Context sensitive popup menu in the Enterprise Manager

This will show the Register Database wizard:

Register Database Wizard, welcome page

Click next to see the needed database and authentication information:

Register Database Wizard, database page

Alias
A user defined alias to display in the Enterprise Manager.
Database
The full path and file on the server of the database file.
Username
The username to use when connecting to this database, this defaults to the username you used when registering the server.
Password
The password for the given username.
Role
The SQL Role that you want to use when connecting to this database.
SQL Dialect
The sql dialect (see InterBase documentation) to use when connecting to this database. This defaults to the SQL Dialect entered in the Preferences of Database Workbench.
Characterset
The characterset you want to use when connecting to this database. This is an InterBase connection setting and it has nothing to do with displaying anything inside Database Workbench. You can use the A button next to the drop down box to fetch the default characterset from the database, as used when creating the database.


The next page of the wizard lists the Database Workbench database registration options.