Upgrading Content Manager database

Upgrade your Content Manager database by running a PowerShell script.

Before you begin

To upgrade the Content Manager database you need details of DBA and user credentials and the names of the Content Manager database.

Before running the PowerShell script, if you use an Oracle database, make sure that there are no open database connections.

Make a back-up of your database before upgrading.

About this task

If your existing Content Manager database contains out-of-the-box Automatic Activities in VBScript, the upgrade script will prompt you to confirm that it will convert those Activities from VBScript to C#. VBScript is no longer supported.

Procedure

  1. On a system that meets the prerequisites for database installation and upgrade scripts, open PowerShell.
  2. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • For a Microsoft SQL Server, AWS RDS-MSSQL or Microsoft Azure database, navigate to Database\MSSQL\
    • For an Oracle database, navigate to Database\Oracle\
  3. Type the following command to upgrade your Content Manager database:
    & '.\Upgrade Content Manager database.ps1' 
  4. Follow the instructions in the PowerShell console to upgrade the database.

Results

The database upgrade modifies the structure of the database tables. Depending on the amount of data in your existing database, the upgrade process may take some time.

The database upgrade also deletes any legacy templating code (that is, VBScript, JScript or XSLT templates) as well as any legacy Automatic Workflow Activities (that is, Activities using VBScript). If any such code is in use during the upgrade, the upgrade aborts.

Please note that if your implementation of SDL Tridion Sites contains hotfixes that were released after the SDL Tridion Sites 9.5 release, messages such as the following may appear during the upgrade process:

Failed to execute query: ORA-01408: such column list already indexed

Query: CREATE INDEX IX_T_PUBLICATION_PRIORITIES_02 ON
T_PUBLICATION_PRIORITIES(CHILD_PUBLICATION_ID, SEQUENCE_ID)
TABLESPACE SESSION_DATA

These messages appear intentionally because they may refer to manual changes to the database that you made yourself. If you see this type of message and it does not refer to a change you made, you may safely ignore it and continue upgrading. The upgrade process is robust and able to handle these changes to indices, constraints and so on.

What to do next

If you encounter problems upgrade, consult SDL Tridion Sites Customer Support for assistance. Do not attempt to fix the database.