Upgrading your main Content Delivery databases using PowerShell

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

Before you begin

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. On a system that meets the prerequisites for database installation and upgrade scripts, open PowerShell.
  3. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • For a Microsoft SQL Server, AWS RDS-MSSQL or Microsoft Azure database, navigate to Database\MSSQL\
    • For an Oracle database, navigate to 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 Customer Support for assistance. Do not attempt to fix the database.