0

Stored procedure in on-premises SQL Server is used to call another app through 'xp_cmdshell'. Now I am trying to do the same on Azure SQL Database. Of course 'xp_cmdshell' is not supported there, so I need workaround.

I was thinking of using Azure Functions as a bridge between Azure SQL Database and app on VM.

  1. Is it possible to call Azure Function from Azure SQL Database using stored procedure?
  2. Is it possible to call app on Azure VM from Azure Function?
user3037556
  • 13
  • 7

2 Answers2

0

  1. Not at the moment. The workaround is to create a Timer-based Azure Function that polls the data every "x" minutes or seconds.

  2. As long the app on Azure VM expose an HTTP endpoint, and you configure the network and the firewall correctly, yes.

mauridb
  • 1,467
  • 9
  • 12
  • 1. Thanks for solution but I already have implicit periodic execution. What I need is possibility to do it explicitly. – user3037556 Mar 09 '20 at 08:38
0

The best practice is to use Azure Automate to run tasks on the VM then using a pipeline in Azure Data Factory you can invoke the runbook using a webhook

CodeSerendipity
  • 74
  • 5