Failed to compare two elements in the array.

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Failed to compare two elements in the array.

Postby ScottN » Sun Mar 11, 2012 12:21 pm

Hello,

I'm using SQL Compare 10 to link to a 2008 TFS Source Control versus a database on SQL Server (10.50.1600).

I had received a couple of errors about that an object already existing. After removing the offensive objects, I'm now receiving this error:

Failed to compare two elements in the array.
Index was out of range. Must be non-negative and less than the size of the collection.


Any suggestions on how I can troubleshoot this issue?

Note: I have successfully done this using the same server and different databases - and it works quite nice to show deployment issues or rogue development not checked into TFS.
ScottN
 
Posts: 1
Joined: Sun Mar 11, 2012 12:11 pm

Postby Brian Donahue » Tue Mar 13, 2012 5:33 pm

There is probably a situation where something is still missing from the scripted schema. Did you get the option to submit the error report to Red Gate and did you put your email address on the error report? This will help us find some of the diagnostic information around the problem.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Fri Mar 16, 2012 10:18 am

We still haven't got your error report. Unfortunately, we cannot find the offending object name without the error report. Sorry for the inconvenience.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Wed Mar 13, 2013 5:47 pm

This had been tracked down in another support issue and the issue was fixed in version 10.2.3.1. It had something to do with a lack of support for Columnstore Indexes.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests