Posted: 11 May 2016 12:21 EDT Last activity: 11 May 2016 13:15 EDT
Pega 7 Upgrade cleanup Automation
In the split schema upgrade process, coming from one old 6.x pega schema converting to 7.x pega_data and pega_rules, there is a manual cleanup step to identify unused tables that are residual in the PEGA_DATA schema from the old originating system. These tables could vary depending on what pega version one is upgrading from. Pega provides a manual step to remove these. The problem is, I am currently helping with 17 upgrades in process, more on the way, and would like a general script to solve most of this cleanup by our script conversion team. I anticipate we will still want to check manually for any misses, and improve this list.
This is the script we have derived by one of our upgrading teams. Can we get confirmation that there is no issue removing these from PEGA_DATA schema for our script conversion team? All of these should be unused in the PEGA_DATA schema correct?...
Did you make this list by using the Optimize Schema wizard? In general it looks fine to me. If you are following the upgrade using 1 database process then you will also have unused data tables in your rules schema that need to be cleaned up. If you are following the upgrade using 2 database process then you will only have the old rules tables to remove from the data schema.