Question
Nordea
SE
Last activity: 6 Oct 2020 9:37 EDT
Migrating Database from Oracle to MS Sql
Hi,
We have applications running on Oracle 19c and Pega v8.4.2 and in future, we may want to move to another DB vendor (say MS Sql). I understand connect-sql rule could be impacted as sql syntax may change but want to know more about any other rule or area in which we should thoroughly test. Appreciate it if anyone can share his/her experience on such migration.
Pegasystems Inc.
US
this may not be what you want exactly, it is related to pegacloud migration (from on-prem, you should definitely look into this option if possible), but a lot of principles apply:
https://community.pega.com/knowledgebase/articles/migrating-pega-cloud-services/migration-overview
https://community.pega.com/marketplace/components/pega-cloud-readiness-tool
Nordea
SE
@KevinZheng_GCS . Thanks for your reply. Moving to the cloud is still in the investigation phase. Let me know if you have any advice for an on-premise application.