What are the challenges you face when working across database platforms? Take the survey

comparing db with archive db

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.  


  • Options
    Alex BAlex B Posts: 1,146 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?
Sign In or Register to comment.