Index Out Of Range Error

kyle_vaske

I am getting the error message "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" and I cannot figure out what is wrong here. The 2 databases that I am comparing are exact copies of each other (ie.-Production database was moved to new server via Backup/Restore in planning phase of a server migration) that are hosted on different servers. I've seen other error messages about database case sensitivity, but I have verified that both servers have the same collation.

Anything else I can try to get this fixed and able to use the SQL Compare tool?

AlessandroAlpi

Hey @kyle_vaske
could you please add further details? Please include the error stack trace (you should see the error in details clicking on the error link, if present) and also the repro step.
Are you replacing the database without re-linking it?

Thanks

kyle_vaske

Redgate support responded and informed me that I was on an older version of SQL Compare that did not support SQL Server 2016 yet. After I upgraded to 13.1, the issue has been resolved.