Documentation Center

Upgrading the UGC database using PowerShell

On a Windows machine, upgrade your existing Oracle or Microsoft SQL Server UGC database by running a PowerShell script.

Before you begin

If you need to upgrade your database server to a supported version, do so before performing this task. Back up your UGC database, perform your database server upgrade, and restore your UGC database.

To upgrade the UGC database itself, you need details of DBA and user credentials and the name of the database.

Procedure

  1. Close all connections to your database server.
  2. If you have not done so already, make a back-up of your database for safety reasons.
  3. Open Windows PowerShell from the Windows Start Menu.
  4. 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\
  5. Type the following command to upgrade your UGC database:
    & '.\Upgrade User Generated Content database.ps1' 
  6. 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.