You’re offline. This is a read only version of the page.
Announcements
35
I haven't found any articles outlining the primary differences (if any) between Azure SQL database and an on-Premise database via Data Gateway for running PowerApps applications.
I'm using on-premise databases now, but thinking about migrating the PowerApps back-ends to Azure. Any gotchas I should be aware of first?
Thanks!
Hi @pyee,
For your first question, the On-premise SQL Server and Azure SQL Server have same Delegation functionality. More details about the Delegable data sources, please check the following article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list
For your second question, I think an app connects to a Azure SQL Server has a better performance than an app to On-premise SQL Server.
For your third question, there are also some known limits in SQL Server connector, please check the following article for more details:
https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations
Best regards,
Kris
Share
Report
All responses (
Answers (
