Posted: 17 Mar 2016 4:55 EDT Last activity: 6 Apr 2018 19:26 EDT
Pega 7.1.6 to Pega 7.1.8 - Data Schema Changes
On Page 34 of the Update Deployment Guide, Step #4, there are instructions on how to execute the Data Schema update to Pega 7.1.8. We will be making this update from Pega 7.1.6.
Before we manipulate the schema containing the client's data, we need to assure them that the changes to the Data Schema will not impact their data. In order to reassure them, they are asking for a high-level list of the changes to be made to the Data Schema.
Can someone please provide that information? We need it to begin our update.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
You can run the generateDDL utility with UpgradeDataOnly true option in Pega 7.1.8 distribution image that will give you all the alter statements which is required from Pega 7.1.6 to Pega 7.1.8 update. Running this statement will not impact on your current 7.1.6 system as its generates only DDL delta changes between7.1.6 to 7.1.8.
Thank you for this information. We will make sure to do this, if we must. However, there is no high-level explanation or documentation which can be provided? We have to analyze the DDL generated by the utility? I ask because our time is at a premium, so if there is any existing reference material, that would same us having to review and understand what could be potentially ambiguous DDL statements, which is potentially time-consuming.
The generated DDL contains only delta changes between Pega 71.6 to Pega 7.1.8. This utility will compare your current schema (Pega 7.1.6) with OOTB Pega 71.8 schema then generates the delta DDL. Once you generate the DDL you should be able to find all the schema changes. This utility may take 5-10 minutes to execute.
As per I know there are two columns (pxCommitDateTime and pxSaveDateTime) are added for all the tables in data schema.
So there is no other source of information for determining the data schema changes between Pega 7.1.6 and Pega 7.1.8, other than to generate the DDL? There is no documentation that details the data schema deltas per release?
Please let me know your response. I do not want to have to generate and then interpret a DDL if I do not have to.
Thank you for the information. Unfortunately, I am looking for an explanation or documentation regarding the changes made in the Data Schema for an update from Pega 7.1.6 to Pega 7.1.8. The explanation you provided is quite helpful for an overview of the entire update process, but I am looking for actual changes versus process.
If you can let me know the high-level changes made to the Data Schema between Pega 7.1.6 and Pega 7.1.8, that would be very helpful.
Majority of the data schema changes in Pega 7.1.8 are the addition of the pxSaveDateTime (when a save request is issued by the PRPC Rule space) and the pxCommitDateTime (when the INSERT/UPDATE is executed). You can view the scripts for database changes between Pega 7.1.7 and Pega 7.1.8 that are created in the directory 'scripts'.