Case Data Migration question when Database vendor is changed between source and destination
Hi,
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.
Regards,
Santanu
WellsFargo
IN
Tata Consultancy Services
IN
Can these external tools read and create Pega-encrypted BLOB? Is it verified or tested?
WellsFargo
IN
Yes its verified and tested. When ever an on premise application is to Pega Cloud ( SAAS service) , Pega follow the same process to move the on prem data to Cloud.
Thanks,
Suman
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.
Thanks,
Suman