“Index was outside the bounds of the array” while Compare SQL schema by SQL compare tool

I got one problem from comparing database schema as i use Red gate SQL Compare 6 , after initialization of the compare databases error is coming as following

"Index was outside the bounds of the array".

Please provide your valuable comments to get resolve this issue.

  • SQL Server 2008 R2: Restore a single filegroup
  • Correct use of SCOPE_IDENTITY function within simple stored procedure
  • Efficient paging with large tables in sql 2008
  • Proper Index Order
  • Replace XML node element with a variable
  • How do I make a copy of a table within SQL Server Enterprise Manager?
  • 3 Solutions collect form web for ““Index was outside the bounds of the array” while Compare SQL schema by SQL compare tool”

    Have you tried upgrading? The latest version released is 8.1, and your issue might have been fixed in the intervening versions. You can also try posting on their support forums…

    Don’t use version 6 on 64 bit versions of SQL Server… Or 7, it appears.

    • The computer running SQL Compare is using a 64-bit edition of Windows
    • One or more of the servers being compared are SQL Server 2005 or higher
    • The Decrypt encryped objects on SQL 2005 and 2008 databases option is selected

    I’ve been using Redgate stuff since 2003 and don’t remember this error.

    I really would consider upgrading…

    Try dbForge Scheme Compare for SQL server. It can compare and synchronize any database scheme. Quick, easy, always delivering a correct result. See how it flies on your database!

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.