Replacing Notification services

Category: sql server streaminsight

Question

Treasurer3 on Fri, 04 Jan 2013 12:02:32


We are using Notification services of SQL Server 2005 in our application. The scenario is that mails will be sent to customers based on different criteria like New Invoices, Overdue Invoices, Invoices due in certain number of days, Invoices for which Amount Exceeds certain value etc. We are using two stored procedures and two tables to achieve this. One stored proc inserts/updates data related to different notifications that are selected by customers. Another stored proc inserts or updates data related to customers who created the notification.

We are now planning to upgrade from SQL 2005 to SQL server 2012. Since notification services are no longer supported in SQL 2012, we are looking for other alternatives. Can someone let us know which among the below would be the best alternative to replace notification services for our scenario.

è StreamInsight

è Data driven subscriptions in SSRS

è Service broker

Also, can someone provide us with any documentation or useful links which would help us in replacing notification services

Replies

DevBiker on Fri, 04 Jan 2013 15:55:19


Because your notifications are going to be based primarily on stored data (and not streaming data), I would look at service broker or a data driven subscription in SSRS ... or something else. Not StreamInsight. Could it be done with StreamInsight? Yes, I'm sure that you could get it to work. But this isn't the kind of use case that StreamInsight is designed for. Unfortunatly, I'm not familiar enough with your other alternatives to tell you if they are better or not.

Michael Malmgren on Tue, 08 Jan 2013 11:16:57


Hello Sonwjanya, I suggest that you take a close look at Boomerang Notification Framework. Boomerang provides a notification services for email, fax,  printing, file/ftp etc. and offers full integration with SSRS to quickly create dynamic notification like overdue invoices or new invoices. Boomerang native interface is SQL (2005 or greater) so my guess is that you just need minor modifications to your stored procs to make this work.

Here a link to the website: www.fuel9.com

Good luck!

/Michael