Register Database Dialog

To make the existing database accessible from DBISAM Manager you should register it. To register a database, select the Database | Register Database menu item, or press Shift+Alt+R. You can also use the Register Database button on the main toolbar or DB Explorer toolbar.

Set the necessary registration parameters in the dialog window. These parameters are divided into three categories:

General

Location
Select the database location - Local or Remote. You can work with the local databases even if the server is stopped.

Local Database Directory
This option is available only if the Location is switched to Local. Set the directory where the database is located by clicking the button and selecting the directory from the tree.

Remote Host
A host name where the database is situated or the IP address of the server.

Remote Port
A TCP/IP port for connecting to the database server.

User Name
User name for connecting to the database server.
Password
Password for connecting to the server.

Remote Database Name
Select the database name to register.

Database Alias
Any database alias that is convenient for you (e.g. DBISAM or My Test Database). This alias will be displayed in the DB Explorer window.

Database Font Charset
Character set to display data in the grid.

   Login prompt before connection
Enables DBISAM Manager to prompt for the user name and password each time you connect to the database.

   Autoconnect on startup
Enables automatic connection to the database when DBISAM Manager is starting up.

Administering

This tab allows you to set the connection parameters for server administering.

Use main account for server administering
Select this position to use the same user name and password as used for main connection to administer the server.

Use specific account for server administering
Select this position to define another user name and password for server administering.

Admin User Name
Select user name for connecting to the server for administering it.

Admin Password
Select user password for connecting to the server for administering it.

Admin Port
Select TCP/IP port for connecting to the server for administering it.

Directories

Default Directory for Extract Metadata
Default directory to store the extracted metadata. Used by the Extract Metadata Expert.

Default Directory for Export Data
Default directory for exporting data. Used by the Export Data Dialog.

Default Directory for Import Data
Default directory for importing data. Used by the Import Data Wizard.

Logs

Metadata Changes
You can enable logging all the metadata changes to the SQL log file. Check option Enable Logging Metadata Changes and set the name of the log file. All metadata changes within the current database will be logged to the specified file.

SQL Editor
To enable logging SQL queries and error messages to the SQL log file check option Enable Logging SQL Editor and set the name of the log file. All the queries prepared or executed in SQL Editor and Visual Query Builder will be logged to the specified file.

See also:

Create Database Wizard Register Host Wizard