Question
Upgrade/Update Pega Data Schema
We are planing to update from Pega 7.1.5 version to Pega 7.3.1 version. I am looking for following information -
During In-Place Update process of Data schema using following script -
./update.sh --dataOnly true
(A) what is/are the change(s) this script exactly make in existing Data Schema(of Pega 7.1.x version), so that it updated to Pega 7.3.1 Data Schema?
(B) Does this script make any change in DDL level ( e.g. - change definition of any table, view, trigger or any other database element) ? Or it changes at DML level (e.g. - add/modify/delete any extra row in any ).
(C) There are multiple Data Schema for different applications, do we need to update all of them separately? My understanding is - we have to update them individually, because our application is using classes mapped to some tables which reside on other Data Schema. Please confirm.
(D) There are few additional schema, some of the Pega classes are mapped to tables reside in this schema. Do I need to update them as well? My understanding is - we have to update these database schema as well. Please confirm.
Note -
1. Current Configuration -
OS - Red Hat Linux Server v6.5
Application Server - Oracle Weblogic Server 12c
Datbase Server - Oracle 12c R1 Enterprise DB Server (12.1.0.1)
Database - Split Schema.
2. I do not have any update.sh script for reference, so that I can check from the script.
Thanks in advance for suggestion and help.
Thanks a million for your response.
For my Question (C) and (D) - there is no OOTB shipped data schema related tables in those additional schema. Hence, I understand - we do not need to upgrade them separately.
You no need to run the data schema upgrade seperately for other dedicated work schemas. However after upgrade is completed then there is a Upgrade->Application Schema Wizard landing page that will help you identify any new columns are added to OOTB pc_work and data related tables that need to be added your application specific tables,
Please find the answers
A) what is/are the change(s) this script exactly make in existing Data Schema(of Pega 7.1.x version), so that it updated to Pega 7.3.1 Data Schema?
This will not touch customer case objects
(B) Does this script make any change in DDL level ( e.g. - change definition of any table, view, trigger or any other database element) ? Or it changes at DML level (e.g. - add/modify/delete any extra row in any ).
Yes it will make the DDL changes. This apply for only Pega OOTB shipped tables and all the changes are additive no deletes
(C) There are multiple Data Schema for different applications, do we need to update all of them separately? My understanding is - we have to update them individually, because our application is using classes mapped to some tables which reside on other Data Schema. Please confirm.
Do you have multiple data schemas? I am not sure how that is configured. Could you please provide more details on what those multiple data schemas contains.
Generally there is one rules schema and one data schema (which includes OOTB pega shipped data schema tables). You can have multiple application specific schemas which holds work tables not Pega tables.
(D) There are few additional schema, some of the Pega classes are mapped to tables reside in this schema. Do I need to update them as well? My understanding is - we have to update these database schema as well. Please confirm.
Please clarify whether you have any OOTB shipped data schema related tables in those additional schema. If not then you no need to upgrade them separately.