Documentation Center

Upgrading your Content Delivery Microsoft SQL Server databases

After you have upgraded your database server to a supported version, run a number of SQL scripts to upgrade your Content Delivery Microsoft SQL Server databases (Content Data Store and Experience Manager database, if using). Run these scripts for each database you are upgrading.

Procedure

  1. Back up your database.
  2. Access your SDL Web 8.5 installation media.
  3. Navigate to Database\Scripts\MSSQL\.
  4. If you are upgrading from SDL Tridion 2013 SP1 HR1, run the following scripts:
    Relative path and filenameDescription
    Shared\80\GENERAL_SET_VERSION.sqlSets the version of the database.
    Upgrade\71_80\TCD_TABLES_UPDATE.sqlUpdates tables.
  5. Regardless of which version you are upgrading from, always run the following scripts:
    Relative path and filenameDescription
    Shared\85\GENERAL_SET_VERSION.sqlSets the version of the database.
    Upgrade\80_85\TCD_TABLES_UPDATE.sqlUpdates tables.