Daily Data Compare

kjmcsd

Is there a way I can automate Data Compare to compare databases and email me the results everyday in a report fashion?

Sergio R

Hi,

Yes, you can automate Data Compare, if you have the Pro version, by using the command line tool.

For example if you run the following command:

sqldatacompare /db1:WidgetStaging /db2:WidgetProduction /Export:C:\WidgetResults.csv

it will compare DB WidgetStaging with DB WidgetProduction and export the results to WidgetResults.csv

For more information on how to use the command line please see:
http://documentation.red-gate.com/display/SDC12/Using+the+command+line

The results will be exported in a csv file: http://documentation.red-gate.com/display/SDC12/Exporting+the+comparison+results

SQL Data Compare has no email capability however, you will have to use another tool to pickup the file and email it to you regularly.

Thank you,