Database Server Upgrade

After you upgrade Control-M/EM or Control-M/Server to 9.0.27, you must upgrade the dedicated BMC-supplied PostgreSQL database or your external PostgreSQL, Oracle, or MSSQL database to one of the supported versions described in Database Upgrade Scenarios.

If you are connected to a dedicated BMC-supplied PostgreSQL database, the Control-M component upgrade does not affect the database operating system, and you must also upgrade the dedicated database to PostgreSQL 11.5, 15.3 or 17.6.

The following procedures describe the database server upgrade process:

Database Upgrade Scenarios

The following table lists the supported upgrade options to upgrade to 9.0.27 based on your database and version.

Database

Source Database Version

Upgrade Action Steps

PostgreSQL (Dedicated BMC-Supplied)

11.5

  1. Upgrade to Control-M 9.0.22.

  2. Upgrade to PostgreSQL 15.3.

MSSQL

2017

  1. Upgrade to Control-M 9.0.27.

  2. (Optional) Upgrade to MSSQL 2019, 2022, or 2025.

MSSQL

2019

  1. Upgrade to Control-M 9.0.27.

  2. (Optional ) Upgrade to MSSQL 2022 or 2025.

MSSQL

2022

  1. Upgrade to Control-M 9.0.27.

  2. (Optional ) Upgrade to MSSQL 2025.

MSSQL

2025

Upgrade to Control-M 9.0.27.

PostgreSQL (Existing)

  • 11.x

  • 12.x

  • 13.x

  • 14.x

  1. Upgrade to Control-M 9.0.22.

  2. Upgrade to PostgreSQL 15.x.

PostgreSQL (Existing)

  • 15.x

  • 16.x

  • 17.x

  • 18.x

Upgrade to Control-M 9.0.27.

Upgrading an External PostgreSQL, Oracle or MSSQL Database Server

This procedure describes how to upgrade an external PostgreSQL, Oracle or MSSQL database server after you upgrade Control-M/EM or Control-M/Server.

  • If you upgrade an external PostgreSQL database server in a High Availability environment, you must perform this procedure once on the primary node.

    • Begin

    1. Verify that the database server version is supported, as described in Product Availability & Compatibility.

    2. Verify the database server requirements, as described in Database Server Requirements.

    3. Contact your DBA to upgrade your database server.

      • If the connection properties changed in the new database server, update the Control-M/EM or Control-M/Server configuration to point to the new location, as described in Control-M/EM Database Hostname or Parameter Changes.

      • (Oracle only) You can upgrade Control-M to version 9.0.27 and use Oracle 12c as an external database server, but you must upgrade your external database server to a supported version before you start up Control-M components.