sqltransactionsmsmqservice-broker

Should I use MSMQ or SQL Service Broker for transactions?


I've been asked by my team leader to investigate MSMQ as an option for the new version of our product. We use SQL Service Broker in our current version. I've done my fair share of experimentation and Googling to find which product is better for my needs, but I thought I'd ask the best site I know for programming answers.

Some details:

Things I've discovered so far:

Am I missing something? Is there a clear winner here? Any thoughts, experiences, or links would be valued. Thank you!


Solution

  • Having just migrated my application from Service Broker to MSMQ, I would have to vote for using MSMQ. There are several factors to take into account, but most of which have to do with how you are using your data and where the processing lives.

    Things to consider no matter what you choose