Documentation Center

Creating the UGC database using PowerShell

Use PowerShell to install the UGC database if you are not installing a Microsoft SQL Server database in a Microsoft Azure SQL Database Cloud hosting environment.

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:
    • For a Microsoft SQL Server, AWS RDS-MSSQL or Microsoft Azure database, navigate to Database\MSSQL\
    • For an Oracle database, navigate to Database\Oracle\
  3. Type the following command to install the UGC database:
    & '.\Install User Generated Content database.ps1' 
  4. Answer Yes if you are installing an AWS RDS-MSSQL 2016 database and you see the following prompt:
    This database server version is not supported. Supported database server versions are 'Microsoft SQL Server 2012 SP3',
    'Microsoft SQL Server 2014 SP2', 'Microsoft SQL Server 2016 SP1'. Do you want to continue anyway?
  5. Follow the instructions in the PowerShell console to create the database.

Results

You have created the User Generated Content database.