This was a weird one because it is clearly a bug in the software. I am running version Professional of RedGate SQL Compare and I kept getting this error after performing an upgrade.

This error reads:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Work around

After trial and error I figured out what the problem was, at least in my use case because maybe it isn’t limited to what I found. This problem presents itself if you have “NOT FOR REPLICATION” on a table and you have the option “Ignore NOT FOR REPLICATION” in your ignore list. You will get the above error upon doing the comparison. I just had to turn that ignore off and it fixed the problem for now. Not ideal, but can’t move forward without doing this.

I submitted the error report to RedGate already, feel free to do the same.


Leave a Reply

Your email address will not be published. Required fields are marked *