Question
2
Replies
23
Views
Posted: October 6, 2020
Last activity: October 6, 2020
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.
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/knowledgebase/articles/migrating-pega-cloud-services/assessing-and-planning-your-migration
https://community.pega.com/knowledgebase/articles/migrating-pega-cloud-services/assessing-your-premises-application-migration
https://community.pega.com/knowledgebase/articles/migrating-pega-cloud-services/download-client-cloud-migration-gap-assessment-worksheet
https://community.pega.com/marketplace/components/pega-cloud-readiness-tool