sqldatacompare /db1:WidgetStaging /db2:WidgetProduction /Export:C:\WidgetResults.csv
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
Comments
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:
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,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools