Deploy Azure Web Application with Non-Azure Database

Question

Is it possible to deploy a .Net based web application in Azure with SQL Database in non-Azure environment?
If yes, will there be any performance issues like connection time lag etc?

Thanks in advance!

Answer 1

@David , As Kalyan mentioned, the scenario/requirement that you're trying to accomplish is very much possible. Performance depends on various factors.

There are a few ways to connect your on-prem database with App service; using VNet Integration with VPN gateway, Hybrid Connections, see the doc Access on-premises resources for more details: https://learn.microsoft.com/azure/app-service/web-sites-integrate-with-vnet#access-on-premises-resources

Also, Just to highlight, Azure offers a number of ways to host your application code.
Azure offers several ways to host websites: Azure App Service WebApps (PAAS solution), Virtual Machines (IAAS), Service Fabric, Azure Storage (for static website) and Azure Static Web Apps.
The term compute refers to the hosting model for the computing resources that your application runs on. The flowchart in the doc, will help you to choose a compute service for your application.

https://learn.microsoft.com/azure/architecture/guide/technology-choices/compute-decision-tree#features

• This article helps you understand the options and make the right choice for your web application.

Answer 2

Yes..

Performance will depend on bandwidth of the network connectivity, type of connection and transaction payload size.

Please see below link where similar discussion happened..

https://learn.microsoft.com/en-us/answers/questions/179143/connect-from-azure-web-apps-to-on-premises-sql-ser.html

Answer 3

Thank you @KALYANBRATA DHAR , @ajkuma

Will there be any lag in connection to SQL DB as both Web App and SQL DB are in 2 different environments? (slowness / performance issues etc.)