Enable SQL Service Broker in SQL Azure
Service Broker should be available in Windows Azure.
This request is now covered under the new Managed Instance offering → https://azure.microsoft.com/en-us/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/
Covered under new Managed Instances does not solve the issue for many. What about classic Azure SQL (single databases)?
do anyone have any alternative for SIGNAL R to work
Provide Alternatives please
Jamie Thomson commented
Service Broker became available in (what used to be called) SQL Azure yesterday (2018-03-07) with the announcement of the GA of Azure SQL Database Managed instance:
We’re excited to announce the preview of Azure SQL Database Managed Instance, a new deployment option in SQL Database that streamlines the migration of SQL Server workloads to a fully managed database service. This new Managed Instance deployment option provides full SQL Server engine compatibility and native virtual network (VNET) support.
With Managed Instance, you can continue to rely on the same SQL Server tools you’ve used and loved for years—in the cloud, too. These include features such as native database restore, SQL Agent, Database Mail, Service Broker, Common Language Runtime (CLR), and Change Data Capture.
So I guess this uservoice ticket can be closed, right?
Please do add "Service Broker"
Michal Poreba commented
As others before me I have a case where a potential move to Azure was abandoned at POC stage because of missing Service Broker which can be an effective tool to distribute load, implement data centric messaging solution right in the database and very importantly allow for asynchronous processing in SQL Server (asynchronous triggers). Another scenario is near real-life data consolidation from multiple source databases. Are there any plans of enabling it in Azure one day, or is it completely of no interest or value to Microsoft?
If you don't want to support the Broker then provide a valid alternative that the .Net SqlDependency can use instead.
Matthew Whited commented
Bummer this is still missing... it's only been 8 years
Such a let down, my organisation were about to adopt Azure big time but having come across this we are having to back out of it and select an alternative. Very surprising for Microsoft to not offer this.
No Service Broker on SQL azure is becoming a deal-breaker for us. We are using SQL azure for many years for our tool and now this is a blocker. Not able to upgrade new features in our tool.
Rob Shenfield commented
Big ditto with the rest of the comments here.
The same here too, i already configured and developed my app to provide real time data to my clients and finally got the azure do not support sql service broker.
Alternatively if anyone fixed the issue plz post here so i may also use it.
This was a major disappointment when I saw that a mature technology such as Service Broker was not a supported technology within SQL Azure. But yet, newer technologies, still in their early years (like In-Memory OLTP) are supported. Would love to see support for Service Broker added.
We use the service broker to feed real time data changes to our data base w/o impacting the performance of the original SQL update.
This is useful when using SignalR.
Kristian Williams commented
This was a dealbreaker for us transferring a client to Azure SQL instances, SQL Broker is mission critical for them, and it's just awesome.
Shane Milton commented
Would like to see this added so that we could implement "Asynchronous Triggers". Without this, our options are:
1) Actual Triggers. But this isn't an option because this introduces unacceptable performance delays inside of our transactions.
2) A "poor man's queue in the database" with external asynchronous processes that poll tables in the database to determine if a message should be inferred. Because of the external nature and additional moving parts, this exponentially increases the delayed effect of this asynchronous trigger and greatly increases the complexity of the solution and maintenance/support efforts.
Todd Davis commented
We use the service broker to feed real time data changes to our data warehouse w/o impacting the performance of the original SQL update.
David Smith commented
We started to migrate some web apps from on-prem to azure, but we ran into the roadblock of Service Broker and SqlDependency not being supported. We need a means to call our .NET code when changes are made to specifiable data in a db. Either Service Broker and SqlDependency OR .NET Framework CLR integration with CLR Triggers OR some new and improved means.
Daniel Mills commented
Ok, an even 600 votes. Time to renew the plan for service broker!
The scenario that's interesting under this architecture is integration with the service bus and specifically eventhub. If service broker enables update message posting to eventhub then granular data transactions can be easily replicated to other systems.