We are doing upgrade of a NBAA application(Pega 7.1.9) to Pega 8.6(CDH+CS) and we upgraded the dev environment following standard Pega upgrade approach. Due to Framework re-structure two step upgrade has been performed in DEV environment.

  (Pega 7.1.7  >> Pega 7.1.9 >> Pega 8.6)

Now for Higher environment to minimize the overhead(millions of data in live application) of two step upgrade we are planning to have a data migration based approach. We need to know does Pega execute any DML changes while running the upgrade scripts?

Is there any place where those queries are saved in to an environment that is recently upgraded.

Can you please let me know if this approach will work for SIT / Higher env?

Set up a fresh Pega 8.6 server with required framework.

Copy the Rule Schema from lower environment which is already remediated post upgrade(current dev)

Copy application specific tables(with data) of Data and Marketing Schema from existing SIT to the new pega8 set up

Find out common tables in Pega Data and truncate / rename as tablename_BK and bring those tables with data again from existing SIT env

Then compare the DB difference in Data and Marketing Schema . This was way are able to generate only the DDLs to synch up the structure.

Apply those DDLs to synch up the structure of the new SIT Data schema