This was a weird one because it is clearly a bug in the software. I am running version 18.104.22.16828 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
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.