Upgrading views or tables in the product databases

To successfully upgrade your version of Reports, you must generate an updated SQL, and upgrade views or tables in your product databases.

About this task

Note: For eMessage, skip this section.

Procedure

Complete the following tasks to upgrade views or tables in the product databases:
  1. Generate updated SQL, as described in Generating view or table creation scripts.
  2. Run the SQL scripts that you generated earlier against the product system table databases.
  3. For Campaign and Interact, create reporting views or tables by using the new SQL and the SQL scripts that are provided with your reports packs.