Documentation Center

Creating the Subscription database using PowerShell scripts

Use a PowerShell script to create the Microsoft SQL Server or Oracle database for Subscription.

Before you begin

An installation or upgrade of this database on a Windows machine requires Windows PowerShell 3.0 and Microsoft .NET Framework 4.0 or higher.

About this task

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 a Subscription database:
    & '.\Install Audience Manager Subscription Management 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. Repeat this procedure as needed.

Results

You have created one or more Subscription databases.

What to do next

When you create the Subscription databases, you will need to retain the database details when you come to installing and configuring subscription on the presentation server.