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
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.