== 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 [http://colinjack.blogspot.com/2008/05/playing-with-mass-transit.html 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'