0

I am aware of the difference between a service broker (centralized) and service bus (decentralized). Is it not that multiple SQL Servers communicating using their Service Broker are considered a decentralized service bus? Why not?

Many thx.

1
  • Is there a reason for the down voting? How can I improve my question?
    – geeko
    Jan 17, 2023 at 10:08

1 Answer 1

0

The work performed by Service Broker is centralized though. It is a central point of services that manage messages and handle queuing, between applications and databases:

SQL Server Service Broker provide native support for messaging and queuing in the SQL Server Database Engine and Azure SQL Managed Instance. Developers can easily create sophisticated applications that use the Database Engine components to communicate between disparate databases, and build distributed and reliable applications.

Use Service Broker components to implement native in-database asynchronous message processing functionalities. Application developers who use Service Broker can distribute data workloads across several databases without programming complex communication and messaging internals. Service Broker reduces development and test work because Service Broker handles the communication paths in the context of a conversation.

1
  • I guess if I consider one SQL Server to represent one service, then it will be a bus.
    – geeko
    Jan 18, 2023 at 4:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.