What is the best approach to migrate our PRPC systems from Oracle to Postgresql.
1. Migrate the entire database using Data Migration tools(like 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. What happens to Application Data in this case?
In case of approach 2 we are worried we will have to reconcile all the rules that were created for so many years. So is it safe to use approach 1 which means the base Pega install will also be migrated using DB migration tools?
It still doesn't answer questions about Application Rulesets. I'm not looking at Data importing utilities itself but looking at the best way to move from oracle to Postgres.
If we are able to migrate all the data including RULES and DATA schema to Postgres using migration utilities, will there be any issues. Does Pega tables have any metadata which makes it think that its running on Oracle even if we migrated the data?