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.
Every cloud will have the tools to migrate the data from OnPrem to Cloud. For an instance AWS has Database Migration Services (DMS) and Schema Conversion Tool ( SCT) to migrate the data from one database to other database.
Reach out to the respective cloud team and research on the options in your cloud provider.