Documentation Center

Creating the UGC database

You can use a PowerShell script to create a Microsoft SQL Server or Oracle database for UGC.

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.

Procedure

  1. Open Windows PowerShell from the Windows Start Menu.
  2. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • Database\MSSQL\ or
    • Database\Oracle\
  3. Type the following command to install the UGC database:
    & '.\Install User Generated Content database.ps1' 
  4. Follow the instructions in the PowerShell console to create the database.

Results

You have created the User Generated Content database.