在 azure 中获取有关插入或更新数据库的通知的服务代理的替代方法是什么? [英] 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.你可以在 官方用户语音.应该使用替代方法Azure VM 上成熟的 SQL Server 或使用某种消息队列，如 Azure 存储队列(更新/创建/等时，将消息作为通知发送到队列，另一端作为接收器).

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

来自评论部分:

对于存储队列的使用，有一个 官方教程 效果很好.除配置外，您还需要将消息插入队列" 和将下一条消息出队列" 部分.因此，您的解决方案可能如下所示:您的应用程序正在数据库中进行更改 => 完成后，应用程序将消息插入队列 => 完成后，该消息应与其他应用程序一起在另一端出队(应该是另一端)收到有关更改的通知).

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 中获取有关插入或更新数据库的通知的服务代理的替代方法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！