7

I found that SQL Server Service Broker is not supported in SQL Azure. Service Broker is a very attractive choice for our event notification needs. But before committing to it I wanted to make sure it will be supported by Microsoft in the future. The fact that SQL Azure does not support Service Broker worries me. Is it the first step towards retiring Service Broker? We have plans to migrate our application to Azure in the future and I was trying to figure out whether Microsoft would be supporting Service Broker in the future versions of SQL Azure. I tried with lot of googling but I didn't get a definitive answer. Is anyone aware why Microsoft hasn't support Service Broker on SQL Azure and whether it is going to support in the future?

Thanks, Sathish

Artemix
  • 2,113
  • 2
  • 23
  • 34
Sathish
  • 101
  • 2
  • 6
  • It seems this is still unknown. However, there is the Azure Queue Service which might be worth a look. http://www.windowsazure.com/en-us/develop/net/how-to-guides/queue-service/ – udog Mar 20 '13 at 03:48
  • In the cloud world, a service broker inside a PaaS database server doesn't really make sense. You have a selection of external service brokers (that don't even need to be in Azure) that you can easily spin up and use. – Nick.Mc Jun 18 '19 at 00:11
  • The Service Broker feature is currently only supported on a managed instance of Azure SQL Database and can only be used within the instance. https://azure.microsoft.com/en-us/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/ – user8128167 Jun 18 '19 at 21:50

1 Answers1

6

Support for service broker in SQL Azure has some technical challenges that Microsoft hasn't resolved yet. For example, service broker supports routing messages between servers. Implementing that functionality may be difficult in the sql azure environment and low on the priority list. Microsoft has made no indication that they are deprecating service broker, and I'd be surprised if it doesn't end up in azure eventually.

There is the same situation for sql clr support in azure. It's a great idea if you can figure out how to keep someone from causing problems with poorly written code.

Microsoft rarely comments on when these types of features will be added, they just show up one day. Also, it's important to remember that sql azure is not designed to replace all instances of SQL Server. It is designed to be a simple db that has enough features to be useful to a fairly wide audience. They recommend that If you require the extra functionality then run SQL Server in a VM.

StrayCatDBA
  • 2,740
  • 18
  • 25