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 server | 9 | 9.1 | 9.5 | 9.6 |
|---|
| Microsoft SQL Server 2016 SP2 | Y | D | N | N |
| Microsoft SQL Server 2017 | Y | Y | D | D |
| Microsoft SQL Server 2019 | N | N | Y | Y |
| Microsoft Azure SQL Database | Y | Y | Y | Y |
| AWS RDS-MSSQL 2017 | Y | Y | Y | D |
| AWS RDS-MSSQL 2019 | N | N | N | Y |
| Oracle Database 11g Release 2 patch set 11.2.0.4 | Y | N | N | N |
| Oracle Database 12c patch set 12.2.0.1 | Y | N | N | N |
| Oracle Database 18c (18.3) | N | Y | Y | D |
| Oracle Database 19c (19.3) | N | Y | Y | Y |
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 server | 9.5 | 9.6 |
|---|
| Elasticsearch 7.10 | N | Y |
| Elasticsearch 7.7 | Y | N |
The support history for the Elasticsearch database plugins is as follows:
| Database server | 9.5 | 9.6 |
|---|
| Ingest Attachment Processor Plugin | Y | Y |
| ICU Analysis Plugin | Y | Y |
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):
| Prerequisite | Description |
|---|
| Powershell software | Powershell 5.0 or higher |
| Operating system | An operating system that supports Powershell of 5.0 or higher and any client software for the database you intend to install. |
| Environment variables | For 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 Framework | Microsoft .NET Framework 4.8 or higher. |
| Database client software | For 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. |
| Java | Powershell 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. |
| 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. |