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

VFPeter · October 11, 2018 8:06PM

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 · October 11, 2018 8:38PM

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?

Image: https://us.v-cdn.net/6029854/uploads/editor/4f/xthdlkj8yilt.jpg

Image: https://us.v-cdn.net/6029854/uploads/editor/rw/c7mki98bkl2d.jpg

VFPeter · October 12, 2018 2:19PM

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 · October 15, 2018 10:54AM

@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.

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk