Question

2
Replies
44
Views
Arjun Kariyappa Maradi Banakar (arjunkmb)
Coforge DPA
Pega Lead System Architect
Coforge DPA
IN
arjunkmb Member since 2011 5 posts
Coforge DPA
Posted: 3 weeks 2 days ago
Last activity: 3 weeks ago
Posted: 26 May 2021 3:54 EDT
Last activity: 27 May 2021 13:51 EDT

Steps for Pega Upgrade & DB migration (oracle to Postgre)

Hello there, 

This is regarding Upgrade & DB migration (Vendor change).

We have a requirement to migrate from Oracle 12c to Postgre 11 while upgrading from v7.3 to v8.5 for an on premise application.

Based on this below link, i assume the migrate.bat or ./migrate.sh script takes care of upgrading the tables only if the target DB vendor is same as source DB vendor (ex: Oracle to Oracle). Can someone please confirm this?

https://community.pega.com/knowledgebase/articles/keeping-current-pega/85/pega-platform-version-83-and-earlier-migrating-rules-and-objects-new-rules-schema

Also, what are the sequence of steps to be followed for upgrade & migration with below requirements?

is there a recommended data migration tool from Pega to be used for this?

Requirements:

Note: This is 24*7 application which is not allowed for more than 4 hrs of downtime.

1. Upgrade platform from v7.3 to v8.5

2. move/migrate from Oracle 12c to Postgre11 with size of 4TB

 

Thanks,

Arjun

Pega Platform 8.5.3 System Administration Upgrades Financial Services Lead System Architect Upgrade