Error - Index was outside the bounds of the array

[sgreene]

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

[Tom Harris]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521