Upgrading your main Content Delivery Microsoft SQL Server databases manually

Run a number of SQL scripts to upgrade your Content Delivery Microsoft SQL Server databases. Run these scripts for each database you are upgrading: the Content Data Store and the Discovery Service database.

Procedure

  1. Back up your database.
  2. Access your Tridion Docs 14 installation media.
  3. E xecute the following SQL scripts:
    
    \Database\Scripts\MSSQL\Upgrade\100_101\TCD_UPDATE_TABLES.sql
    \Database\Scripts\MSSQL\Shared\101\GENERAL_SET_VERSION.sql
    \Database\Scripts\MSSQL\Shared\1011\GENERAL_SET_VERSION.sql
    \Database\Scripts\MSSQL\Upgrade\1011_1100\TCD_UPDATE_TABLES.sql
    \Database\Scripts\MSSQL\Upgrade\1011_1100\TCD_UPDATE_CONFIGURATION_VALUES.sql
    \Database\Scripts\MSSQL\Shared\110\GENERAL_SET_VERSION.sql
  4. Regardless of the release from which you are upgrading, execute the following SQL scripts:
    \Database\Scripts\MSSQL\Shared\111\GENERAL_SET_VERSION.sql
    \Database\Scripts\MSSQL\Shared\CREATE_FK_INDEXES.sql