Media Server 24.1

# Upgrade the Database Schema

Sometimes the schema of the Media Server database must change in order to provide new features or enhancements. This section describes how to upgrade the schema of your training database.

## Internal Databases

If you are using an internal database, schema changes are applied automatically when you start the latest version of Media Server.

## External Databases

If you are using a database that is hosted on an external database server, you must run an upgrade script when you upgrade Media Server. OpenText provides scripts to upgrade to the latest version of the database schema. The following table describes the schema changes for the Media Server database.

Schema version | Media Server version | Script to run to upgrade to latest schema
--- | --- | ---
13 | 23.3 | You are using the latest database schema
12 | 12.13 | Upgrade to the latest schema by running one of the upgrade scripts. For example, to upgrade to the latest schema from version 10 use the following scripts: `my-upgrade_from_v10.sql` (for MYSQL databases) `postgres-upgrade_from_v10.sql` (for PostgreSQL databases)
11 | 12.12
10 | 12.11
9 | 12.7
8 | 12.5
7 | 12.2
6 | 12.1
5 | 11.4

Running one of the upgrade scripts upgrades your database to the latest schema. Older versions of Media Server (with the same major version number) can still use the upgraded database, but do not offer any accuracy or performance improvements associated with the new version.

To upgrade the database schema

1. In the table above, find the version of Media Server that you are upgrading from.

2. Run the corresponding upgrade script for your database, using the same command syntax as used to create the database (see the following topics):

   - Set Up a PostgreSQL Database on Windows
   - Set Up a PostgreSQL Database on Linux
   - Set Up a MySQL Database

   NOTE: Run the upgrade script using the `psql` command-line tool (for PostgreSQL databases) or the `mysql` command-line tool (for MySQL databases). The script contains instructions that are only supported when the script runs through these tools.

3. Start Media Server 24.1, and run training and analysis as normal.

Copyright 2023 Open Text
Version 24.1 | Last updated December 2023

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL Media Server 24.1

Topic Title: Upgrade the Database Schema