Can I compare unique values only?
BenKim
Posts: 10 Bronze 1
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.
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.
Tagged:
Answers
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).