What is the alternative of service broker in azure

问题:

I need to get notification when the user insert or update on database on azure server ... this could happen be Enable_Broker in IIS server. Unfortunately azure does not support Service Broker... Is there Alternative, What I can use to get notification on update or insert database..

回答1:

That is one of the limitations of SQL Azure (i suppose you mean SQL Azure. You may vote for the feature on the official UserVoice. Alternative should be use of full-fledged SQL Server on the Azure VM or use of some kind of messaging queue like Azure Storage Queue (when updating/creating/etc, send the message to the queue as a notification, and a receiver on the other end).

From comments section:

For use of Storage Queues, there is an official tutorial that works very well. Except configuration, you need "Insert a message into a queue" and "De-queue the next message" sections. So, your solution may look like: Your app is doing the change in the database => once it completes, app inserts the message into the queue => once it is done, that message should be de-queued on the other side with other application (which is the side that should be notified about changes).

回答2:

Microsoft has just released "Managed Instance" in preview which supports Service Broker with some limitations (ex: cross-instance service broker is not supported).

Azure SQL Database Managed Instance (preview) is a new capability of Azure SQL Database, providing near 100% compatibility with SQL Server on-premises, providing a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for on-premises SQL Server customers. Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, Managed Instance preserves all PaaS capabilities (automatic patching and version updates, backup, high-availability), that drastically reduces management overhead and TCO.

• Overview of Managed Instance

• Service Broker Differences