Restore the Target Database

Perform these steps if you have made changes to the upgrade environment or to the upgrade files and want to run the upgrade again to verify performance improvement.

  1. In the production test environment, restore the target database from backup.

    This returns the target database to its nonupgraded state so that you can perform another test upgrade.

  2. In the production test environment, perform another test upgrade and evaluate upgrade performance.

  3. Repeat the tuning process and perform test upgrades until upgrade performance is acceptable.

  4. When you have completed tuning upgrade performance in the production test environment, delete and remove the target database.