How can we help you today? How can we help you today?

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

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

Pete
0

Comments

3 comments

Sort by
  • 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
    0
  • 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 


    VFPeter
    0
  • 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.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.