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

roastbeast

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

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