Upgrading the Staging Database
This section describes how to upgrade the Staging schema on a Conversion environment in V2.0.0.1.3 and higher.
Restore the Staging schema before upgrading/updating an existing environment:
Note: Execute this step if you are upgrading/updating an already-setup-for-Conversion environment.
1. Extract ConvSetup.tar from the ..\DAM\Conversion\ folder.
tar xvf ConvSetup.tar
 
2. On the Staging schema, execute the following script:
script restore_ctltbls.sql
 
Note: This script would have been generated during the conversion setup in previous versions starting V2.0.0.1.3 and is also a part of ConvSetup.tar.
3. Upgrade the staging schema (example: STGADM). For instructions, refer to the Upgrade Install section in Installing the DatabaseInstalling the Oracle Utilities Digital Asset Management 25.4 Database.
4. To set up conversion again, follow the instructions in the Preparing the Staging Database section.