Upgrade your existing Audience Manager database by running a PowerShell script.
Before you begin
To upgrade the Audience Manager database you need details of DBA and user credentials and the names of the Audience Manager database.
Procedure
- Close all connections to the database.
- If you have not already done so, back up your Audience Manager database for safety reasons.
- Open Windows PowerShell from the Windows Start Menu.
- 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\
- Type the following command to upgrade your Audience Manager database:
& '.\Upgrade Audience Manager database.ps1'
- Follow the instructions in the PowerShell console to upgrade the database.
Results
The database upgrade modifies the structure of the database tables. If you encounter problems during the upgrade, restore your backup and try again. If your second attempt fails as well, consult
SDL Customer Support for assistance. Do not attempt to fix the database.