Pega Upgrade with Query
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?