Sent Reports via email

litu

Hi,

I just want to know if there's any way to send the SQL Compare reports by email.
I have an scheduled task that runs the comparition every night and I have to go there manually and check if everything's ok. And that depends on my memory (which is not something anyone should rely on). Is there any way to send that report by email?

Thanks in advance,
Litu.

David Atkinson

You can use the /Report command line switch to output a file, which you can subsequently attach to an email.

eg

sqlcompare /db1:WidgetStaging /db2:WidgetProduction /report:"C:
eportsWidgetReport.html" /reportType:Simple

see:
http://documentation.red-gate.com/displ ... ne-/Report: