Documentation Center

Upgrading the UGC Microsoft SQL Server database manually

Run a number of SQL scripts to upgrade your UGC Microsoft SQL Server database.

Procedure

  1. Back up your database.
  2. Access your SDL Web 8.5 installation media.
  3. Navigate to Database\Scripts\MSSQL\.
  4. Only if you are upgrading from SDL Tridion 2013 SP1 HR1, run the following scripts:
    • Shared\80\UGC_SET_VERSION.sql
    • Shared\81\UGC_SET_VERSION.sql
  5. Regardless of the version from which you are upgrading, run the following scripts:
    • Shared\811\UGC_SET_VERSION.sql
    • Shared\82\UGC_SET_VERSION.sql
    • Shared\83\UGC_SET_VERSION.sql
    • Upgrade\83_85\UGC_UPDATE_TABLES.sql
    • Shared\85\UGC_SET_VERSION.sql