Pega Upgrade with Query
Hi
We are upgrading Pega from 8.5 to 8.8. We upgraded Rule schema by running the script in lower region.
For prod implementation we will be moving the Rule Schema from lower region and per below link have to do Data only update on Data schema
Updating the data schema https://docs.pega.com/bundle/platform-88/page/platform/deployment/patch-update-process-data-schema-changes.html
Problem is in Prod we dont have an Id with sufficient privileges to run the scripts update.bat with setupDatabase properties file. Instead we are asked to provide the SQL to DBA to run the scripts.
How will I generate the SQLs that does the same thing that the command "update.bat --dataOnly true" does.
In short I need to do the Dataonly update with out running the script in prod. How to do that?
Accepted Solution
Updated: 28 Feb 2023 12:18 EST
NCS Pte. Ltd
SG
HI @Arvind: You can generate the DDL using generateddl.sh. But the upgrade script does more than creating / altering tables. So I don't see a option to upgrade of Data schema with a sql file instead of PEGA upgrade script.
Thanks.
