Documentation Center

Upgrading the UGC database

If you have UGC (User-Generated Content) installed as a standalone product alongside SDL Tridion 2011 SP1, upgrade your existing Oracle or Microsoft SQL Server UGC 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.

To upgrade the UGC database, 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:
    • Database\MSSQL\ or
    • 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 Tridion Customer Support for assistance. Do not attempt to fix the database.