Santanu Seth (SETHS007)
Tata Consultancy Services
Pega LSA
Tata Consultancy Services
SETHS007 Member since 2017 8 posts
Tata Consultancy Services
Posted: November 24, 2020
Last activity: November 25, 2020
Posted: 24 Nov 2020 7:21 EST
Last activity: 25 Nov 2020 8:47 EST

Case Data Migration question when Database vendor is changed between source and destination


I have a pega application in production with Oracle DB. I need to migrate the application to PostGres DB.


Regarding Rules, there is no issues. My question is on Live Case Data migration.


What are the steps required to migrate live case data (sitting at different stages/assignments) with SLA from Oracle BLOB to PostGres BLOB?


Will the two BLOBs be same? I mean, if we just copy the Oracle BLOB to PostGres BLOB, will it work? Or, I need to develop migration flows and take the case dump from Oracle and run the dump through migration flows in PostGres? Will this ensure pxCreateDateTime, assignment sanity, SLA, Goal, Deadline etc. ?


Please suggest the best aproach. This is required for any on prem to cloud migration where PostGres is de factor database for cloud.




Pega Platform Case Management Technology Services Lead System Architect Upgrade