Skip to end of metadata
Go to start of metadata

Introduction

New midPoint releases usually bring new features. New features usually require the extension of midPoint data model to use them. The changes of data model usually require extension of the schema of the database that stores midPoint objects. This is the usual routine for most midPoint upgrades.

MidPoint distributions come with the database upgrade scripts. These scripts contain a set of SQL commands (usually ALTER TABLE commands) that extend the schema of existing database. The scripts are designed to be non-desctructive, therefore they can safely be executed over a database that is populated with data.

Upgrade Script Location

DistributionScript location
Binary<distribution root>/config/sql/_all/
Source<source code root>/config/sql/_all/

The script file name is constructed in a form:

<database>-upgrade-<from version>-<to version>.sql

e.g. postgresql-upgrade-3.1-3.1.1.sql is an upgrade script for PostgreSQL databse that upgrades midPoint 3.1 to midPoint 3.1.1.

Executing the script

The scripts should be executed by the usual way the SQL script is executed for any particular database. Perhaps the best way is to use command-line tools. Please refer to the documentation of your database system for the details. E.g. the upgrade script for PostgreSQL database is usually executed like this:

See Also

 

  • No labels