Upgrading Audience Manager database

Upgrade your existing Audience Manager 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 Audience Manager database you need details of DBA and user credentials and the names of the Audience Manager database.

Procedure

  1. Close all connections to the database.
  2. If you have not already done so, back up your Audience Manager 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 Audience Manager database:
    & '.\Upgrade Audience Manager database.ps1' 
  6. Follow the instructions in the PowerShell console to upgrade the database.

Results

The database upgrade modifies the structure of the database tables.

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.