Question

3
Replies
402
Views
 Abubaker Syed (AbubakerS)
Amazon Corp

Amazon Corp
US
AbubakerS Member since 2015 21 posts
Amazon Corp
Posted: March 20, 2017
Last activity: April 13, 2017
Posted: 20 Mar 2017 17:32 EDT
Last activity: 13 Apr 2017 12:30 EDT
Closed
Solved

Migrating from Oracle to Postgresql

Hello,

We are planning to migrate our PRPC systems from Oracle to Postgresql. I would like to understand what is the best approach for this.

1. Migrate the entire database using Data Migration tools(AWS DMS) from Oracle to Postgresql

2. Install Pega Base Product on Postgresql and then extract the custom code as RAP and install on top of base product

Anyone who did database migrations, can you share your experience?

System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 22 Mar 2017 8:59 EDT
Santanu Bhattacherjee (Santanu)
PEGA
Senior Manager - Sales Automation
Pegasystems Inc.
IN

Hi


I will go for approach 2 . Install first and then import the Product. This to me is the safe approach.


Others can comment.

Accepted Solution

Posted: 4 years ago
Posted: 30 Mar 2017 15:37 EDT
Shanthini Charles (Shanthini_Charles)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hello Abu,


This could be based on your application design. Incase you have your application design as a cake like structure the way how PRPC suggests then you would only RAP them as custom rulesets and import into the new migrated system.


Let us know if you still have any questions?


Regards,


Shanthini Charles