Run a number of SQL scripts to upgrade your UGC Microsoft SQL Server database.
Procedure
- Back up your database.
- Access your SDL Web 8.5 installation media.
- Navigate to Database\Scripts\MSSQL\.
- 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
- 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