Sql2msmq Overview

Sql2msmq solves a problem inherent in database application development; how to discover when stored data changes.

Database aware applications typically must discover the following table activity:

• insert
• delete
• update

Several architectural solutions already exist which may help a developer solve this problem.

• Server side notifications using MS Sql Notification Services
• Table polling (yech !)

These solutions may be undesirable for any number of reasons.

• Sql Notification Services
  • Complex configuration
    • multiple configuration files
  • Additonal server process instance
    • polling merely moved to the server
  • Notification receipt
    • File, SMTP, HTTP inefficiencies
• Table Polling
  • Lame
  • Doesn't scale

Enter Sql2msmq.

Sql2msmq intgrates into your MS Sql Server runtime, and posts a message onto an MS Message Queue whenever a table event occurs. All your application needs to do is subscribe to that queue. If you have multiple subscribers it is relatively trivial to set up a message bus system as described  here

Since MS Message Queue is now shipped as a standard component on all Microsoft operating system versions, you can feel confident that your application will 'just work'