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 Web 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 2013 SP1 HR1 and if you use Oracle, then you used an SQL script called CreateTridionSYSUser.sql to create and name an SQL SDL Web administrator user when you first installed the Content Manager database. 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 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.)