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

Can I compare unique values only?

On version 15.
Is it possible to compare unique values only?
Currently, one side has duplicates. The other side does not. The duplicates show up as differences. 
But I have a case where it is desirable to know if (select distinct ...) result is the same. 
Please advise.


  • Options
    Hi @BenKim

    Thank you for your post. Are you able to clarify what it that you are trying to achieve in SQL Data Compare? If you only want to deploy the rows that exists in the Source rather than rows that exist in both but contain differences, then you are able to filter this at the bottom of the comparison window to show only rows that exist in the left (source DB).
Sign In or Register to comment.