Is there way to send email on Deploy?

VBJV

Is there any way to configure an automated email to be sent when the Deploy part of SQL Compare 12/13 is used? I would love to have an alert or recap email of what got deployed from what server to what server go out to the team. It would act as sort of a safe guard to make sure only the necessary changes were deployed - and possibly catch stuff that didn't get pushed and should have - if someone reviews it.

AlexYates

(But you cannot trigger emails directly from SQL Compare.)

AlexYates

Apologies, just saw the notification.

Well you could write your own PowerShell to call the SQL Compare command line to do all the things, and then wrap that into some higher level orchestrated process using Octopus or similar.

Or you could buy a licence. No point reinventing the wheel. SQL Compare does not have email functionality because that's not how it's designed to be used.

If you want a full pipeline orchestration solution with email notifications the tool Redgate provides is DLM Automation, which plugs into the likes of Jenkins, Octopus, VSTS etc and should give you what you need.

AlexYates

I recommend using something like Octopus Deploy to orchestrate your deployments. You can add steps to call Redgate to generate diff reports/upgrade scripts, trigger emails pre/post deployment, carry out a manual review of diff reports, and execute scripts as required.

Octopus Deploy:
https://octopus.com/

Integrating Octopus and Redgate DLM Automation (a PowerShell interface for SQL Compare and other RG tools):
https://documentation.red-gate.com/display/DLMA2/Octopus+Deploy+step+templates+reference

VBJV

Thanks, for the tip on Octopus Deploy. However, since we are not licensed for SQLToolbelt Pro. We can't use the DLM Automation tool to integrate the two. Any other suggestions?