Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Service Broker and WCF interoperability

Does SQL Server Service Broker have an ability to communicate with a WCF service? I wanna create a Service Broker service which will send some xml message to WCF service for processing. Of course SQL Server instance and WCF service are deployed on different machines. Is it possible to somehow configure SB service to achieve such goal?

like image 807
Marian Zagoruiko Avatar asked Oct 07 '22 14:10

Marian Zagoruiko


1 Answers

No. SSB can only communicate with another SSB instance. There is a WCF SSB channel but that is using SSB as a transport channel to a WCF service, the WCF service requires a local SQL Server for this channel to work (it can be SQL Express instance).

like image 175
Remus Rusanu Avatar answered Oct 10 '22 08:10

Remus Rusanu