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

Compares and synchronizes SQL database content.

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

Postby paule123 » Thu Feb 23, 2012 11:37 pm

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 9:07 pm

Postby Brian Donahue » Fri Feb 24, 2012 11:46 am

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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests