Upgrading Contact Details (Content Manager)

Only if your are upgrading from SDL Tridion 2013 SP1 HR1, the Contact Details metadata (for example, which ones are used for identification or e-mail) has been moved from the configuration file to the Audience Manager database, and you must upgrade your existing Contact Details by running a PowerShell script.

Before you begin

To upgrade the Audience Manager Contact Details you need details of DBA and user credentials and the names of the Audience Manager database.

Procedure

  1. Back up your OutboundEmail.xml to a safe location.
  2. Close all connections to the database.
  3. If you have not already done so, back up your Audience Manager database for safety reasons.
  4. Open Windows PowerShell from the Windows Start Menu.
  5. 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\
  6. Type the following command to upgrade your database:
    & '.\Upgrade Extended Details in Audience Manager database.ps1' -ConfigurationFile OutboundEmail.xml
  7. Follow the instructions in the PowerShell console to upgrade the Contact Details.

Results

The script updates the Contact Details in the database to match the information in your existing configuration file.

What to do next

If you encounter problems during the upgrade, restore your backup and try again. If your second attempt also fails, consult SDL Customer Support for assistance. Do not attempt to fix the database.