Options

comparing db with archive db

Dsmith4914Dsmith4914 Posts: 1 New member
in SQL Data Compare
I have 2 databases. We are migrating historical data off of one to the other. I wanted to query every table on both databases and find only the identical values. This would mean that the migration process only completed half the copy and delete process. Is there a way to do this?  BTW I don't care about the ones that don't match, as that is expected behavior.  
Tagged:
· Share on Twitter

Answers

  • Options
    Alex BAlex B Posts: 1,132 Diamond 4
    If you use SQL Data Compare you can include the Identical values
    ​

    but the differences will also be included as well - meaning you can't show ONLY the identical values (unless they are both all identical and you have chosen the option above).

    The identical entries are separate from the others:
    ​

    But you can generate a csv export that only includes the Identical values:
    ​
    which will give you a summary csv and then a separate csv for each table showing the type of difference ("Same" in this case) and the column values:
    ​

    I hope that helps!
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.