Upgrading your Microsoft SQL Server database manually
After you have upgraded your database server to a supported version, run a number of SQL scripts to upgrade your SQL Server database.
Closing open connections
Regardless of the version from which you are upgrading, you must close all connections to your SQL Server database server before starting the upgrade.
Upgrading your SDL Tridion R5 5.3 SQL Server database manually
If you are upgrading from version 5.3 of SDL Tridion R5, access your SDL Tridion 2011 SP1 installation media, navigate to Database\TDM\Scripts\MSSQL\, and run the following database scripts located in the relative paths provided, in the order given:
- Upgrade\53_53SP1\TCD_UPDATE_DYNAMIC_LINKS.sql
- Upgrade\53_53SP1\TCD_UPDATE_TRACKINGKEYS.sql
- Upgrade\53SP1_54\TCD_UPDATE_TAXONOMIES.sql
- Upgrade\53SP1_54\TCD_UPDATE_INDEXES.sql
- Upgrade\54_54SP1\TCD_TAXFACETS_INDEX.sql
- Upgrade\54SP1_60\TCD_ITEMMETA.sql
- Upgrade\54SP1_60\TCD_METADATA.sql
- Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
- Upgrade\54SP1_60\TCD_TAXONOMIES.sql
- Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
- Upgrade\54SP1_60\TCD_TRACKING.sql
- Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
- Upgrade\60_61\TCD_PREVIEW.sql
- Upgrade\60_61\TCD_BINARYVARIANTS.sql
- Shared\61\GENERAL_SET_VERSION.sql
Upgrading your SDL Tridion R5 5.3 SP1 SQL Server database manually
If you are upgrading from version 5.3 SP1 of SDL Tridion R5, access your SDL Tridion 2011 SP1 installation media, navigate to Database\TDM\Scripts\MSSQL\, and run the following database scripts located in the relative paths provided, in the order given:
- Upgrade\53SP1_54\TCD_UPDATE_TAXONOMIES.sql
- Upgrade\53SP1_54\TCD_UPDATE_INDEXES.sql
- Upgrade\54_54SP1\TCD_TAXFACETS_INDEX.sql
- Upgrade\54SP1_60\TCD_ITEMMETA.sql
- Upgrade\54SP1_60\TCD_METADATA.sql
- Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
- Upgrade\54SP1_60\TCD_TAXONOMIES.sql
- Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
- Upgrade\54SP1_60\TCD_TRACKING.sql
- Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
- Upgrade\60_61\TCD_PREVIEW.sql
- Upgrade\60_61\TCD_BINARYVARIANTS.sql
- Shared\61\GENERAL_SET_VERSION.sql
Upgrading your SDL Tridion 2009 SQL Server database manually
If you are upgrading from version 2009 of SDL Tridion, access your SDL Tridion 2011 SP1 installation media, navigate to Database\TDM\Scripts\MSSQL\, and run the following database scripts located in the relative paths provided, in the order given:
- Upgrade\54_54SP1\TCD_TAXFACETS_INDEX.sql
- Upgrade\54SP1_60\TCD_ITEMMETA.sql
- Upgrade\54SP1_60\TCD_METADATA.sql
- Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
- Upgrade\54SP1_60\TCD_TAXONOMIES.sql
- Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
- Upgrade\54SP1_60\TCD_TRACKING.sql
- Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
- Upgrade\60_61\TCD_PREVIEW.sql
- Upgrade\60_61\TCD_BINARYVARIANTS.sql
- Shared\61\GENERAL_SET_VERSION.sql
Upgrading your SDL Tridion 2009 SP1 SQL Server database manually
If you are upgrading from version 2009 SP1 of SDL Tridion, access your SDL Tridion 2011 SP1 installation media, navigate to Database\TDM\Scripts\MSSQL\, and run the following database scripts located in the relative paths provided, in the order given:
- Upgrade\54SP1_60\TCD_ITEMMETA.sql
- Upgrade\54SP1_60\TCD_METADATA.sql
- Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
- Upgrade\54SP1_60\TCD_TAXONOMIES.sql
- Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
- Upgrade\54SP1_60\TCD_TRACKING.sql
- Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
- Upgrade\60_61\TCD_PREVIEW.sql
- Upgrade\60_61\TCD_BINARYVARIANTS.sql
- Shared\61\GENERAL_SET_VERSION.sql
Upgrading your SDL Tridion 2011 SQL Server database manually
If you are upgrading from version 2011 of SDL Tridion, access your SDL Tridion 2011 SP1 installation media, navigate to Database\TDM\Scripts\MSSQL\, and run the following database scripts located in the relative paths provided, in the order given:
- Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
- Upgrade\60_61\TCD_PREVIEW.sql
- Upgrade\60_61\TCD_BINARYVARIANTS.sql
- Shared\61\GENERAL_SET_VERSION.sql