Documentation Center

Upgrading Content Manager database

Upgrade your Content Manager database by running a PowerShell script.

Before you begin

To install or upgrade SDL Tridion databases on a Windows machine requires Windows PowerShell 3.0 and Microsoft .NET Framework 4.0 or higher.

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.

Procedure

  1. Open Windows PowerShell from the Windows Start Menu.
  2. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • Database\MSSQL\ or
    • 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.

Please note that if your implementation of SDL Tridion contains hotfixes that were released after the SDL Tridion 2013 SP1 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 Customer Support for assistance. Do not attempt to fix the database.