question

MichaelMcGovern-8199 avatar image
0 Votes"
MichaelMcGovern-8199 asked OuryBa-MSFT edited

Microsoft - Please build a plugin for SQL Server to allow seamless, reliable integration with Azure Service Bus

Hi,

Often overlooked in microservices is how to get atomic transactional behaviour between database update and message publishing.

One solution is the transactional outbox.

It would be good if SQL server could have a plugin to do this - something a bit like CDC but instead of writing to a CDC table it attempts to publish to ASB (and also persisting to a table for undeliverable messages).

This would give very fast, reliable delivery to ASB.

For the edge case of ASB not being reachable a background scheduled thread would need to retry any undelivered messages.

Sql Server Service Broker seems too clunky to me - but please advise if this can be used as a clean solution for an outbox to Azure Service Bus.

Thanks
Michael

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MichaelMcGovern-8199 Thank you for your feedback. We appreciate it. We will share and elevate your suggestion with the SQL Server product team.

Please Note: Azure is working on a new Self-Serve option for customers to share and vote on product feedback. When available, you will be able to go to https://feedback.azure.com/ and share/up-vote product feature ideas.

Regards,
Oury

0 Votes 0 ·

0 Answers