Creating Tracking and Subscription databases using PowerShell scripts

Use a PowerShell script to create Microsoft SQL Server or Oracle databases for Tracking and Subscription.

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.

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:
    • Database\MSSQL\ or
    • Database\Oracle\
  3. Type the following command to install a Tracking database:
    & '.\Install Outbound E-mail Tracking database.ps1'
  4. Type the following command to install a Subscription database:
    & '.\Install Outbound E-mail Subscription Management database.ps1'
  5. Follow the instructions in the PowerShell console to create the database. Repeat this procedure as needed.

Results

You have created Tracking and Subscription databases.

What to do next

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