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)
- 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_ADMINenvironment 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:
- If you run Microsoft Windows Server 2022, you can use Microsoft .NET Framework 4.8.1. You can download Microsoft .NET Framework 4.8.1 from the following location: https://dotnet.microsoft.com/en-us/download/dotnet-framework/net481
- If you run Microsoft Windows Server 2019 x64, you must use Microsoft .NET Framework 4.8. You can download Microsoft .NET Framework 4.8 from the following location: https://dotnet.microsoft.com/en-us/download/dotnet-framework/net48
- 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_HOMEenvironment 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.