Documentation Center

Prerequisites for Content Delivery database upgrade scripts or index migration scripts

The machine on which you run the upgrade scripts to upgrade Content Delivery relational databases or the migration scripts to migrate OpenSearch indexes must meet certain requirements.

To run PowerShell database scripts for databases on the Content Delivery side, you require a machine that meets the following requirements:
PowerShell
You require Microsoft Windows PowerShell 5.1. You can download Microsoft Windows Management Framework 5.1, which includes Microsoft Windows PowerShell 5.1, from this location: http://aka.ms/wmf5download
Operating system
You require an operating system that supports both the required PowerShell software and any software for the database you intend to install. As a general rule, ensure that the latest (security) updates are installed on your operating system.
Database client software
For Oracle databases, you require both of the following:
  • Oracle Services for Microsoft Transaction Server (ORAMTS)
  • Oracle Data Provider for .NET (ODP.NET)
For maintenance, configuration and debugging purposes, RWS recommends that you also install the Oracle SQL Developer PL/SQL IDE (or SQL*Plus) and Oracle Net.
Environment variables
For Oracle databases where you have defined a Net Service Name for each database in a tnsnames.ora file, you must also have defined a TNS_ADMIN environment variable. Set it to the directory where tnsnames.ora resides.
Microsoft .NET Framework
You require a .NET Framework version. The one to use depends on your Windows Server operating system version:
Java
PowerShell database scripts for databases on the Content Delivery side run Liquibase scripts, which require either Eclipse Temurin OpenJDK 17 using the HotSpot JVM (available for download at https://adoptium.net), or Oracle JDK 17. Make sure that the JAVA_HOME environment variable is set.
Security
You need to be logged in as a user with sufficient security clearance. For example, to run a script that installs a database, you must be logged in as a user with rights to create that database.