Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Starting with version 3.0.0 of tia Core Content Server, the database (both protocol and metadata) is managed by Flyway. Flyway is a framework that allows the version management of databases using scripts and records their execution. This allows applications to self-manage the database even when structure changes, data is migrated, or complex SQL-based operations are performed.

...

Flyway updates a database from one version to the next using so called migrations. The database migrations are done using use SQL-scripts which are applied and against the usage database. This is recorded tracked in a Flyway history table in the database. Upon each start, the tracked executions in the history table is are compared to the existing scripts and if scripts are missing, the migrations will be against the migrations prepared. If one or more migrations have not been applied yet, they get applied.

We can use two types of files: versioned migrations and repeatable migrations.

...