Preparation of the Database Schemas
In the database schemas used for infrastructure such as access management or audit logging, each schema must have the required tables and any other database objects.
The Database Migration Tool is available for preparing new database schemas and updating database schemas already used by Cadenza to the latest version.
-
The Migration Tool
DatabaseMigrationTool.bat(Windows) orDatabaseMigrationTool(Linux) you will find in the Disy Cloud and in the 'tools/' directory of the Cadenza installation. -
The documentation for the tool can be obtained through the disy Cloud, but is also included in this documentation: How to use the Database Migration Tool
Database Schemas already used by Cadenza (relevant when updating)
When updating to a new Cadenza version, use the Migration Tool to check whether database updates are also required.
A backup is strongly recommended before an update as the structure of the database schemas will be changed.
Empty Database Schemas (relevant when installing)
Also make sure …
-
that the user used by Cadenza is granted write access to the created tables and
-
that all created tables are included in backups.
The following applies to Cadenza Data Stores (CDS) in a PostgreSQL database: PostGIS must be activated for the tables (CREATE EXTENSION postgis).
HSQL Test Database schemas
HSQL database schemas can be used for testing purposes for some infrastructure functions. You will find the corresponding scripts for their creation in the directory <cadenza_home>/CadenzaDesktop/data/. The user who starts the database server and the Cadenza web server requires write access to this directory.