Database

Settings for:

me personally

the entire installation

Legend: Preferences apply only to you personally. System settings apply to all users across the entire installation. System settings that can only be edited by users with administrator rights are displayed in grey to users without administrator rights. Here, they are marked with an asterisk *.
Preferences

There are no preferences for the database.

System settings

This page is used to configure or replace the database. Because of its significant impact, this page can only be edited by users with administrator privileges. Other users can only see the fields, not the buttons.

Database settings*

This windows displays the currently used database settings. If these were not changed during the installation or update respectively, the settings of the H2 database provided by default are displayed.

Migration*

You can migrate the application data to another database at any time. However, this must have been separately installed previously. By clicking the button Migrate application data to another database a dialog box is opened, where you can enter the settings of the new database.

Recovery*

In rare cases in can happen that the bundled H2 database is damaged. Then a recovery can be tried by clicking the button Recover the H2 database. Before that the program backs up the existing database file as backup_DATE_TIME_bl.h2.db in the workspace directory.

SQL debugger*

Upon clicking this button a window of the same name opens, which allows to enter SQL commands to the database. This function is intended for the purpose of error analysis and should only be applied after consultation with the support of BL Banking.

Merge accounts*

In rare cases, it may happen that identical accounts are displayed twice. You can then use this button to merge the accounts.