How can we help you today? How can we help you today?

Index Out Of Range Error

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?
kyle_vaske
0

Comments

2 comments

Sort by
  • 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
    AlessandroAlpi
    0
  • 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.
    kyle_vaske
    0

Add comment

Please sign in to leave a comment.