Compare data in two tables with different names similar structure in same database

VFPeter

I just downloaded the latest trial version of SQL Data Compare (13). I want to compare data in 2 tables in the same database with similar structure but different names. 

How do I do this?

p.s I do not see <Object Mapping> tab as mentioned in some threads with similar questions. See https://forum.red-gate.com/discussion/14496/is-it-possible-to-compare-different-table-names

VFPeter

I manage to make some progress. I was able to select the two tables and also set the comparison key. But when I execute "Compare", it is not including these two tables. Any ideas? 

VFPeter

It worked!  There were some issues with some of the Field Names. After it was corrected, everything worked great!

I do have another question that I have posted here as it is different: https://forum.red-gate.com/discussion/84162/exporting-only-mismatch-fields-to-csv#latest 

Tianjiao_Li

@VFPeter

Thanks for the update! Glad to know you manged to make it work!

I'll have a look of your new question in a minute.