Posted: 2 May 2016 5:17 EDT Last activity: 6 Apr 2018 19:26 EDT
Upgrade from Pega 5.5 to 7.2. pr_log and pr_sys tables missing in generate DDL Scripts
We are upgrading from Pega 5.5 to Pega 7.2 using Single Schema upgrade. When we ran generate DDL query and reviewed the SQL queries generated we see that create queries for below tables are missing. Please let me know how can I get create SQL queries for below tables and the reason why they are missing in query generated by DDL script in first place. Also let me know can go ahead and run upgrade.sh (by disabling generate and apply DDL parameters) without below tables being created.
**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.
We had initial discussion with one of the engineer from Pega (email@example.com). As per him, our database size is huge so he suggested first doing Single Schema Upgrade and test everything and then split the schema. Need your inputs from your if this is the best approach (Single Schema upgrade + Test and then Split the schema)?
Posted: 5 years ago
Updated: 5 years ago
Posted: 2 May 2016 7:19 EDT Updated: 2 May 2016 7:24 EDT
We have already done the steps you have mentioned (skimming, purging etc). We want to have second opinion on what are the considerations which may prompt us to go for Single Schema upgrade initially, instead of Split schema upgrade. Is there any upper limit on the data size for Split schema upgrade? If possible please involve someone from your team to get the response. Do you have any numbers on what was the maximum size of database which was upgraded to 7.x successfully? We want to save lot of rework latter on as Single Schema vs Split Schema is a big decision.
Note: In our case the we are upgrading from 5.5 to 7.2