Break on comparison failure
PaulJJ
Posts: 1 New member
If I simply want to validate that databases are the same, I'm not always interested in how many records differ, just that they do - is there any option to break a table comparison as soon as a differing record is found, or to restrict the number of differences to a finite number?
Tagged:
Answers
That is not the intended purpose of SQL Data Compare, the idea is that it creates a deployment script to sync the data in the tables.
You may be able to utilize the "Use checksum comparison" comparison option so that it does a checksum comparison and will only continue to compare if they are different:
Beyond that, unfortunately I don't think there's anything that will help do what you want.
Kind regards,
Alex
Have you visited our Help Center?