Error - Index was outside the bounds of the array

Forum for users of SQL Compare schema synchronization utility

Error - Index was outside the bounds of the array

Postby sgreene » Wed Oct 15, 2008 12:43 am

My first time running compare on this database and got this error (paraphrased)

Registering Database
Reading Object Text:
Index was outside the bounds of the array

Thanks for any help.

Posts: 3
Joined: Fri Feb 08, 2008 3:26 pm

Postby Tom Harris » Wed Oct 15, 2008 11:52 am

Hi there,

I'm really sorry that you've run into this problem. We have a private release of SQL Compare 7.2 that fixes this issue. Please email and they will get right back to you with details.

Apologies again, Tom
Tom Harris
Posts: 308
Joined: Wed Oct 06, 2004 2:45 pm

Postby Brian Donahue » Tue Dec 23, 2008 3:50 pm

Just to add, the patch only fixes this problem in the following conditions:
  • 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

The patch fixes a problem with offset alignment on 64-bit systems -- the program uses pointers to data pages that are only 32-bit friendly and this is what causes the pointer to go out-of-bounds.

There are numerous other causes for the error that may not be covered by the patch, for instance, inconsistent metadata in the database.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests