Error - Index was outside the bounds of the array

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Error - Index was outside the bounds of the array

Postby sgreene » Wed Oct 15, 2008 1: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.

Sam
sgreene
 
Posts: 3
Joined: Fri Feb 08, 2008 4:26 pm

Postby Tom Harris » Wed Oct 15, 2008 12:52 pm

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 support@redgate.com and they will get right back to you with details.

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

Postby Brian Donahue » Tue Dec 23, 2008 4: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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests