Question
Issue in Migrating Data from Pega6.2 single schema to Pega 7.4 split schema
Our Application is currently in pega 6.2 , Our Current dB size in prod is 3 TB. We would like to migrate the same to Pega 7.4 in split schema. Estimate to install Pega 7.4 in production may take 4-5 days. Initially we are planning to set of cut off date for Migration. Install and proceed with the data Migration from 6.2 to 7.4 till cut off date, later we will move the delta cut from pega 6.2 to 7.4. Question : 1. we would like to know how to migrate/handle Work objects which are updated in Pega 6.2 post 7.4 installation. 2. Steps to be taken care for Rollback. Please Suggest us all possible solution .
We are already following the upgrade guide, but there is no information about delta data handling in it.
The upgrade guide is generic https://community.pega.com/knowledgebase/documents/pega-platform-74-upgrade-guide
So when you get to the latter stages of the configuration, I'd suggest you also look at the Install Guide based on your DB and application server
https://community.pega.com/knowledgebase/products/platform/deploy?product_version=7071
First and foremost, I know it's a lot of information, but you're best bet is to start with the Upgrade Guide .
The is a migrate script which you can run to help with splitting a single schema into a split schema. But I don't know if you can use this to split the data to a new schema. I've only used this in the past to migrate rules to a new schema.