Documentation Center

Preparing for the Content Manager database upgrade

Before performing your actual upgrade, back up any Custom Pages and Custom URLs, and upgrade the SQL SDL Tridion administrator user for Oracle.

Procedure

  1. If you have Custom Pages, back them up.
  2. If you have Custom URLs, back them up.
  3. For safety reasons, back up your database.
  4. If you are upgrading from SDL Tridion 2009 SP1, note that upgrading will do the following:
    • Remove all items in the Publish Queue
    • Remove all publishing history

    It is advisable to warn your end users that they will need to resubmit any outstanding publish jobs after the upgrade.

  5. If you use Oracle, then you used an SQL script called CreateTridionSYSUser.sql to create and name an SQL SDL Tridion administrator user when you first installed the Content Manager database(s). This script granted certain rights to this user, but these rights have been extended in the current release. As a result, you need to do the following:
    1. Drop the SDL Tridion administrator user account you created at the time (by default, this account would be called TRIDION_SYS).
    2. From the installation media, in the folder \Database\Scripts\Oracle\Tools\ run CreateTridionSYSUser.sql. Give it the same user name (defaults to TRIDION_SYS) and password as the credentials you used before. (If you are upgrading to a new machine, run this script on the new machine.)