Data model release upgrade

Figure 1 explains how major and minor Data Model release upgrades are applied.

Figure 3 Major and minor Data Model release concept

Major data model release

For a major Data Model release, there are two types of packages:

A CREATE package to perform a new complete installation.
An UPGRADE package to upgrade the previous major Data Model installation to the new major Data Model release.

The example in Figure 4 explains a major Data Model release v2.3 to upgrade a v2.2 full install to a v2.3 full install.

The major release includes minor Data Model Releases (v2.2.1 and v2.2.2) that followed the v2.2 Major Data Model Release. The Data Model Manager identifies the changes not already applied to the target database and only applies what is needed.

Figure 4 A major Data Model release v2.3 ALTER

Minor data model release

A minor Data Model release is typically a small change. For example, adding a small number of columns to an existing table or tables. Following a major Data Model release, any minor releases are applied as increments to the CREATE and UPGRADE packages.

In Figure 5, the CREATE package establishes a v2.2 FULL install and then applies a v2.2.1 minor release to bring the installation up to the latest patch release.

Figure 5 A minor Data Model release v2.2.1

The following table describes the process to receive the latest changes for a minor data model release.

Participant status	Example scenario	Process
On the current major Data Model version	Upgrade v2.2 to v2.2.1	In Data Model Manager, upgrade with the minor release package, e.g., UPGRADE v2.2.1 package
On an earlier major Data Model version	Upgrade v2.1 to v.2.2.1	In Data Model Manager: 1. Upgrade with the current major release package, e.g., UPGRADE v2.2 package 2. Upgrade with the minor release package, e.g., UPGRADE v2.2.1 package
New Data Model installation	Install v2.2.1	In Data Model Manager: 1. Install the current major release package, e.g., CREATE v2.2 2. Upgrade to the minor release package, e.g., UPGRADE v2.2.1 package

Participant status

Example scenario

Process

On the current major Data Model version

Upgrade v2.2 to v2.2.1

In Data Model Manager, upgrade with the minor release package, e.g., UPGRADE v2.2.1 package

On an earlier major Data Model version

Upgrade v2.1 to v.2.2.1

In Data Model Manager:

1. Upgrade with the current major release package, e.g., UPGRADE v2.2 package

2. Upgrade with the minor release package, e.g., UPGRADE v2.2.1 package

New Data Model installation

Install v2.2.1

In Data Model Manager:

1. Install the current major release package, e.g., CREATE v2.2

2. Upgrade to the minor release package, e.g., UPGRADE v2.2.1 package