Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Broker to non MS DB Expand / Collapse
Author
Message
Posted Thursday, August 8, 2013 2:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 1:02 AM
Points: 384, Visits: 833
Hi is it possible to run service broker to talk to a non MS DB, the one in question would be MySQL?

Thanks in advance
Allen


Post #1482187
Posted Thursday, August 8, 2013 5:38 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 6:32 AM
Points: 1,890, Visits: 3,472
No, there is no support in other database systems to "talk" service broker protocol.

That doesn't mean that whatever you want to do is not possible. I have used service broker to populate an ElasticSearch index in real-time. This was done by creating a .NET Windows service to RECEIVE from the target queue, process the messages and respond back to initiator. This does not guarantee any transactional consitency, since ElasticSearch can't joint the SQL Server transaction. If the update to ElasticSearch succeeds, but then something fails before I can respond to the initiator and commit, there is no way to rollback the ElasticSearch changes. We were able to live with that, but you need to decide for yourself if that is acceptable in your environment.
Post #1482238
Posted Thursday, August 8, 2013 6:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 1:02 AM
Points: 384, Visits: 833
Hi Nils - thanks - that was my expectation but its great to get confirmation.

Cheers
Allen
Post #1482249
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse