Pega Upgrade: Need help to understand gaps of Azure SQL Database
We are currently on-prem with oracle DB Pega 7x and migrating to Azure with Pega 8.7.
We want to use MS Sql as PaaS in azure but cannot use Azure Managed Instance. Which leaves us with Azure SQL Db.
https://docs-previous.pega.com/platform-support-guide
As per Pega Update Guide , Azure SQL Database is supported with Gaps for 8.7, so we wanted to check one of the gaps mentioned :
Azure SQL Database only allows database-level access, and does not have access to instance-scoped (server-level) features like service broker, SQL Server Agent, and others.
We urgently need to understand if Pega is using instance-scoped (server-level) features - is the Pega engine or code utilizing any features that can be hampered by using Azure sql database?
Pegasystems Inc.
GB
@mitrarii Pega Platform is designed to work with various databases, including Azure SQL Database. While there might be some limitations due to the absence of instance-scoped (server-level) features, Pega has been successfully deployed on Azure SQL Database.
It is important to thoroughly test your specific application and use case to ensure compatibility and performance. If you encounter any issues, you can work with Pega Support to address them.
This answer came from a Pega gen-AI assistant using the below references.
As a Support Center moderator, I reviewed the answer and references for accuracy