How to call a local SQL Server stored procedure from an Azure SQL database?

2
votes

I have a stored procedure in a SQL Server 2014 database on site. I need to call this stored procedure from an Azure SQL database.

How can I implement this?

I have read about elastic queries but I find that elastic queries works for Azure databases only.

1
sqlsql-serverazureazure-sql-databasecross-database
Can you set up a linked server? – Dan Bracuk
no, we cannot set a linked server on Azure. – YogeshR
You can call azure database storedproc from local database,but not reverse.. – TheGameiswar

1 Answers

2
votes

You cannot, unless you move your local database to Azure.

If this was not Azure, you could use linked servers feature, but this is not supported by Azure.

Alternatively you could try to reverse situation and call Azure procedures from your local database, which is supported.

https://msdn.microsoft.com/en-us/library/ms190479.aspx