Upgrading views or tables in the product databases

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

About this task

Note: For eMessage, skip this task.

To upgrade the views or tables in your product databases, complete the following steps.

Procedure

  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.