Initializing Database Schemas

After creating database schemas in your database system, the Database Migration Tool must be used to initialize them. During initialization, the tool creates schema-specific tables, relations, and other database objects required for Cadenza to operate.

The Database Migration Tool is also used for updating existing database schemas when upgrading to a new Cadenza version.

  • The Migration Tool DatabaseMigrationTool.bat (Windows) or DatabaseMigrationTool (Linux) can be found 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: Using the Database Migration Tool

  • For Cadenza running in containers or on Kubernetes, the use of the Database Migration Tool is described on the documentation pages for these platforms: Docker Installation and Kubernetes Installation.

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.