Documentation Center

Content Delivery database server support history

The Tridion Sites 9.6 Content Delivery databases (Content Data Store, Experience Manager database and Discovery Service database), as well as the Elasticsearch database, have changed software prerequisites compared to SDL Tridion Sites 9, SDL Tridion Sites 9.1 or SDL Tridion Sites 9.5. If your current version of Oracle or SQL Server is not supported, upgrade it before upgrading the databases.

Content Delivery databases

In the following table: N=not supported, Y=supported, D=Deprecated (support may be dropped in the following version release):

Database server99.19.59.6
Microsoft SQL Server 2016 SP2YDNN
Microsoft SQL Server 2017YYDD
Microsoft SQL Server 2019NNYY
Microsoft Azure SQL DatabaseYYYY
AWS RDS-MSSQL 2017YYYD
AWS RDS-MSSQL 2019NNNY
Oracle Database 11g Release 2 patch set 11.2.0.4YNNN
Oracle Database 12c patch set 12.2.0.1YNNN
Oracle Database 18c (18.3)NYYD
Oracle Database 19c (19.3)NYYY

Content Delivery Elasticsearch databases

In the following tables: N=not supported, Y=supported.

The support history for the Elasticsearch database itself is as follows:
Database server9.59.6
Elasticsearch 7.10NY
Elasticsearch 7.7YN
The support history for the Elasticsearch database plugins is as follows:
Database server9.59.6
Ingest Attachment Processor PluginYY
ICU Analysis PluginYY

Powershell database upgrade script prerequisites

To run Powershell database scripts, you require a machine that meets the following requirements (any Tridion Sites 9.6 server machine running Windows meets these requirements):
PrerequisiteDescription
Powershell softwarePowershell 5.0 or higher
Operating systemAn operating system that supports Powershell of 5.0 or higher and any client software for the database you intend to install.
Environment variablesFor Oracle databases where you have defined a Net Service Name for each database in a tnsnames.ora file, you have also defined a TNS_ADMIN environment variable. Set it to the directory where tnsnames.ora resides.
Microsoft .NET FrameworkMicrosoft .NET Framework 4.8 or higher.
Database client softwareFor Oracle databases, Oracle Services for Microsoft Transaction Server (ORAMTS) and Oracle Data Provider for .NET (ODP.NET) are both installed. For maintenance, configuration and debugging purposes, RWS recommends that you also have the Oracle SQL Developer PL/SQL IDE (or SQL*Plus) installed, and Oracle Net.
JavaPowershell database scripts run Liquibase scripts, which require either Eclipse Temurin OpenJDK 11 (18.9 LTS release) using the HotSpot JVM (available for download at https://adoptium.net), or Oracle JDK 11. Make sure that the JAVA_HOME environment variable is set.
SecurityYou 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.