Upgrading your Oracle database manually

After you have upgraded your database server to a supported version, run a number of SQL scripts to upgrade your Oracle database.

Upgrading your SDL Tridion R5 5.3 Oracle 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\Oracle\, and run the following database scripts located in the relative paths provided, in the order given:

  1. Upgrade\53_53SP1\TCD_UPDATE_DYNAMIC_LINKS.sql
  2. Upgrade\53_53SP1\TCD_UPDATE_TRACKINGKEYS.sql
  3. Upgrade\53SP1_54\TCD_UPDATE_TAXONOMIES.sql
  4. Upgrade\53SP1_54\TCD_UPDATE_INDEXES.sql
  5. Upgrade\54_54SP1\TCD_UPDATE_TRACKINGKEYS.sql
  6. Upgrade\54SP1_60\TCD_ITEMMETA.sql
  7. Upgrade\54SP1_60\TCD_TAXONOMIES.sql
  8. Upgrade\54SP1_60\TCD_METADATA.sql
  9. Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
  10. Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
  11. Upgrade\54SP1_60\TCD_INDEXES.sql
  12. Upgrade\54SP1_60\TCD_TRACKING.sql
  13. Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
  14. Upgrade\60_61\TCD_PREVIEW.sql
  15. Upgrade\60_61\TCD_SEQUENCE_ITC.sql
  16. Upgrade\60_61\TCD_BINARYVARIANTS.sql
  17. Shared\61\GENERAL_SET_VERSION.sql

Upgrading your SDL Tridion R5 5.3 SP1 Oracle 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\Oracle\, and run the following database scripts located in the relative paths provided, in the order given:

  1. Upgrade\53SP1_54\TCD_UPDATE_TAXONOMIES.sql
  2. Upgrade\53SP1_54\TCD_UPDATE_INDEXES.sql
  3. Upgrade\54_54SP1\TCD_UPDATE_TRACKINGKEYS.sql
  4. Upgrade\54SP1_60\TCD_ITEMMETA.sql
  5. Upgrade\54SP1_60\TCD_TAXONOMIES.sql
  6. Upgrade\54SP1_60\TCD_METADATA.sql
  7. Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
  8. Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
  9. Upgrade\54SP1_60\TCD_INDEXES.sql
  10. Upgrade\54SP1_60\TCD_TRACKING.sql
  11. Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
  12. Upgrade\60_61\TCD_PREVIEW.sql
  13. Upgrade\60_61\TCD_SEQUENCE_ITC.sql
  14. Upgrade\60_61\TCD_BINARYVARIANTS.sql
  15. Shared\61\GENERAL_SET_VERSION.sql

Upgrading your SDL Tridion 2009 Oracle 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\Oracle\, and run the following database scripts located in the relative paths provided, in the order given:

  1. Upgrade\54_54SP1\TCD_UPDATE_TRACKINGKEYS.sql
  2. Upgrade\54SP1_60\TCD_ITEMMETA.sql
  3. Upgrade\54SP1_60\TCD_TAXONOMIES.sql
  4. Upgrade\54SP1_60\TCD_METADATA.sql
  5. Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
  6. Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
  7. Upgrade\54SP1_60\TCD_INDEXES.sql
  8. Upgrade\54SP1_60\TCD_TRACKING.sql
  9. Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
  10. Upgrade\60_61\TCD_PREVIEW.sql
  11. Upgrade\60_61\TCD_SEQUENCE_ITC.sql
  12. Upgrade\60_61\TCD_BINARYVARIANTS.sql
  13. Shared\61\GENERAL_SET_VERSION.sql

Upgrading your SDL Tridion 2009 SP1 Oracle 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\Oracle\, and run the following database scripts located in the relative paths provided, in the order given:

  1. Upgrade\54SP1_60\TCD_ITEMMETA.sql
  2. Upgrade\54SP1_60\TCD_TAXONOMIES.sql
  3. Upgrade\54SP1_60\TCD_METADATA.sql
  4. Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
  5. Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
  6. Upgrade\54SP1_60\TCD_INDEXES.sql
  7. Upgrade\54SP1_60\TCD_TRACKING.sql
  8. Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
  9. Upgrade\60_61\TCD_PREVIEW.sql
  10. Upgrade\60_61\TCD_SEQUENCE_ITC.sql
  11. Upgrade\60_61\TCD_BINARYVARIANTS.sql
  12. Shared\61\GENERAL_SET_VERSION.sql

Upgrading your SDL Tridion 2011 Oracle 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\Oracle\, and run the following database scripts located in the relative paths provided, in the order given:

  1. Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
  2. Upgrade\60_61\TCD_PREVIEW.sql
  3. Upgrade\60_61\TCD_SEQUENCE_ITC.sql
  4. Upgrade\60_61\TCD_BINARYVARIANTS.sql
  5. Shared\61\GENERAL_SET_VERSION.sql