Can SQL Compare be run against multiple targets in one shot?

roastbeast · November 13, 2019 3:07PM

My environment has dozens of workstations, each with the same SQL Server database on them. I'd like to know if SQL Compare can be run in such a way so that one source can be compared to all of these targets in one shot and display a report of any discrepancies.

Thanks

Tianjiao_Li · November 25, 2019 11:30AM

The command utility can do this for you. You'd need to wrap the comparisons in a batch file and then output the report to a file.

All switches can be found on our online documentation: https://documentation.red-gate.com/sc/using-the-command-line

Can SQL Compare be run against multiple targets in one shot?

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk