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

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?


  • Options
    Alex BAlex B Posts: 1,146 Diamond 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,
    Product Support Engineer | Redgate Software

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