comparing mytable and mytable_new in the same database WITH COMMAND LINE (CLI)?
In the GUI, comparing these two is pretty straightforward, using mapping.
However, we have multiple tables in the database (mytable_b and mytable_b_new, etc, etc), and across several servers. So I want to be able to run a script that will bang against each combo and drop a report. I can't seem to find a way of doing this.
I believe in the past we'd built something that created an XML file that SQL Compare would then use, but I'd think this is a common enough scenario that it's standard these days (compare two tables in the same database with different names).
Any idea? Anybody? Bueller?