"Index was outside the bounds of the array" when comparing

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

"Index was outside the bounds of the array" when comparing

Postby paule123 » Fri Feb 24, 2012 12:37 am

SQL Data Compare v
Windows 2008 R2 Enterprise (x64)
SQL Server 2008 R2 Enterprise x64

When I compare an encrypted backup (created with SQL Backup 6.5) to a local database, Data Compare works it's way through the list of tables and then displays "Index was outside the bounds of the array" with the red X. The only thing that might be considered unusual on the affected table is it contains a large number of varchar(max) fields.
Posts: 28
Joined: Tue Feb 12, 2008 10:07 pm

Postby Brian Donahue » Fri Feb 24, 2012 12:46 pm

Hi Paul,

Unfortunately that is not enough information to make any determination about the problem (our fault), but I suspect it's some inconsistency in the schema rather than a backup-reading issue.

I'll send the debugging instructions via email.
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests