Replacing an MSMQ queue with a SQL Server 2005 queue

Write Ahead Blog : Replacing an MSMQ queue with a SQL Server 2005 queue

"...Switching from MSMQ to SQL Server 2005 Service Broker would give them the immediate advantages of persisting messages along with the data in the database and thus provide a single backup/restore solution. And they also get the exactly once in-order semantics of the conversations, internal activation to get rid of the polling NT service, etc.

MSMQ and Service Broker being fundamentally different in their architecture, we realized that proposing a solution from a Service Broker angle seems like a huge change for someone thinking in terms of a single MSMQ queue. So here is a look at incrementally migrating a simple spooling MSMQ application to a Service Broker.

MSMQ and Service Broker being fundamentally different in their architecture, we realized that proposing a solution from a Service Broker angle seems like a huge change for someone thinking in terms of a single MSMQ queue. So here is a look at incrementally migrating a simple spooling MSMQ application to a Service Broker. ..."

This is something (using SQL Broker to replace my MSMQ Queue's) I've been thinking about since I first heard about the SQL Broker.

This post seems a close fit to my use case. Interesting...