Database migration*

On this page, you can migrate the application data to a new database. In preparation for the migration, you must install the new database according to the manufacturer's instructions. No user may work in the application during the migration. The duration of the process varies depending on the amount of data.

First select the database type from the drop-down list. The following are supported: H2, MariaDB, MySQL, Microsoft SQL Server, Oracle Database and PostgreSQL.

In the input fields, enter the data with which BL Banking Web can connect to the new database. JDBC URL and user name are mandatory, a password only needs to be entered if the BL Banking Web user has been created accordingly in the database.

After selecting the database, a sample URL is displayed in the field JDBC URL as an input aid. Replace the placeholder expressions in angle brackets with the actual names. The URLs of the various databases have the following format:

• H2 — jdbc:h2:file:${workspace_loc}/bl;MVCC=true;IGNORECASE=true
  The placeholder ${workspace_loc} is automatically replaced by the path of the workspace directory.
• MariaDB — jdbc:mariadb://<hostname>:3306/<dbname>
• MySQL — jdbc:mysql://<hostname>:3306/<dbname>
• Microsoft SQL Server — jdbc:sqlserver://<servername>:1433;databaseName=<dbname>
• Oracle — jdbc:oracle:thin:@<servername>:1521:<dbname>
• PostgreSql — jdbc:postgresql://<hostname>:5432/<dbname>

By clicking the blue button the connection is checked and the migration started. Progress and completion are respectively displayed on a new page.

Figure: Settings for the database migration