I have 2 tables in the same database and schema named TABLE_NAME_0001 and TABLE_NAME_0002. Can someone please explain how to select these tables for comparison reporting (no sync)?
I can see and select the tables, but selecting the validate button returns "No target table".
You should also be able to highlight both tables in the Schema Browser, and right-click->Compare as well. Compare wizard gens both a summary and a detail diff report.
Doug, I am away from PC now so I could be mistaken but it sounds like you are in ‘compare multiple tables’ not ‘compare table data’. Compare multiple Tables window is all about comparing multiple (or all) tables in one schema to tables by the same (or similar) names in another schema.
Compare Table Data is meant for just a pair of tables and is easier to figure out