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:
|
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
- In the table above, find the version of Media Server that you are upgrading from.
-
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 themysql
command-line tool (for MySQL databases). The script contains instructions that are only supported when the script runs through these tools. - Start Media Server 24.3, and run training and analysis as normal.