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
- Back up your database.
- Access your Tridion Docs 14 installation media.
- 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
- 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