Break on comparison failure

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

  • Alex BAlex B Posts: 626 Rose Gold 4
    Hi @PaulJJ,

    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.