什么是替代服务代理在azure中获取通知插入或更新db？ [英] What is the alternative of service broker in azure to get notification on insert or update db?

问题描述

当用户在azure服务器上的数据库上插入或更新时，我需要获得通知...这可能发生在IIS服务器中的Enable_Broker。不幸的是，azure不支持Service Broker ...是否有替代方法，可以用来获取更新或插入数据库的通知。

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..

推荐答案

这是SQL Azure的一个限制（我想你的意思是SQL Azure。你可以投票在官方UserVoice 。或者应该在Azure虚拟机上使用成熟的SQL Server，或者使用一些类型的邮件队列，如 Azure存储队列（在更新/创建/ etc时，将消息作为通知发送到队列，在另一端发送接收者）。

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).

评论部分：

对于使用存储队列，有一个官方教程。除了配置，您需要将邮件插入队列和对下一封邮件取消队列部分。
所以，您的解决方案可能如下所示：
您的应用程序在数据库中进行更改=>一旦完成，应用程序将消息插入队列=>一旦完成，该消息应为de在另一侧与其他应用程序（这是应该通知有关更改的一侧）排队。

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).

这篇关于什么是替代服务代理在azure中获取通知插入或更新db？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！