Documentation Center

Upgrading your Content Delivery databases using PowerShell

On a Windows machine, upgrade your existing Oracle or Microsoft SQL Server Content Delivery databases (Content Data Store and Experience Manager database) by running a PowerShell script.

Before you begin

To install or upgrade SDL Tridion databases on a Windows machine requires Windows PowerShell 3.0 and Microsoft .NET Framework 4.0 or higher.

If you upgraded your database server to a supported version, close all connections to your database server before upgrading your Content Delivery databases.

To upgrade the Content Delivery databases, you need details of DBA and user credentials and the names of the databases. Perform these steps once for each database.

Procedure

  1. For safety reasons, back up your database.
  2. Open Windows PowerShell from the Windows Start Menu.
  3. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • Database\MSSQL\ or
    • Database\Oracle\
  4. Type the following command to upgrade your Content Data Store:
    & '.\Upgrade Content Data Store.ps1' 
  5. Follow the instructions in the PowerShell console to upgrade the database.

What to do next

If you encounter problems during the upgrade, restore your backup and try again. If your second attempt fails as well, consult SDL Tridion Customer Support for assistance. Do not attempt to fix the database.