Error - Index was outside the bounds of the array

sgreenesgreene Posts: 5
edited December 23, 2008 10:50AM in SQL Compare Previous Versions
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
· Share on Twitter

Comments

  • Tom HarrisTom Harris Posts: 318
    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
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
Sign In or Register to comment.