What are the challenges you face when working across database platforms? Take the survey
Options

Database Mail

dscotlanddscotland Posts: 7
edited March 31, 2006 7:26AM in SQL Compare Previous Versions
With the addition of message queues etc in sql server 2005 its becoming a lot more common now to shove stuff on to a queue with an aysnchronous trigger and them consmue stuff off the queue and send e-mails as theres very little performance impact in doing this.

SQL compare succesfully syncs up all your queues and contracts etc from your development database to your live one the only thing is that its very easy to forget about the database mail profiles that are used to send the e-mails so i thought i might suggest that you look at adding the ability to sync up the all the database mail settings between your development and live environments.

David

Comments

Sign In or Register to comment.