Option 4: Updating the X4 Database

General Information

There is only one update step here:

Updating the X4 database

If you do not want to use the existing X4 database but rather a new X4 database, you must create an empty X4 database before running the Update Tool.

When migrating to versions as of version 7.0.0, schedule entries from the X4 database are automatically migrated to SCHEDULE files in the corresponding projects.

The required data is located in the standalone.xml in the <server_directory>\wildfly\standalone\configuration folder in the <datasources> tag.

We recommend not using the H2DB but a different database type instead.

Depending on the database you use, your JDBC URL might look like this:

SQL Server: jdbc:sqlserver://<ip_adress>:<port>
PostgreSQL: jdbc:postgres://<ip_adress>:<port>
SQLite: jdbc:sqlite:<path/to/sqlitedb/x4.sqlite.db>
H2DB: jdbc:h2:<path/to/H2DB/x4.h2.db

Steps in detail

The Update Tool guides you through the individual steps:

Enter the JDBC URL for the X4 database extension:
jdbc:sqlserver://<ip_adress>:<port>
Enter the database user:sa
Enter the password for the database user:
**

After a successful update, the Update Tool generates a message:
Completed. BYE BYE!