How can we help you today?

How can we help you today?

Daily Data Compare

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

kjmcsd June 16, 2017 15:26

0

Comments

1 comment

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,
Sergio R June 21, 2017 10:04

0

Add comment

Please sign in to leave a comment.