What are the challenges you face when working across database platforms? Take the survey
Options

Error: Index was out of range...

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited March 11, 2004 9:51AM in SQL Compare Previous Versions
Hi Daniel,

What this most likely means is you've got a case-sensitive database, and
two object names have the same case-insensitive name. Can you please check
this? If that's right, try using the 'Treat items as case-sensitive' option
in SQL Compare and that should take care of it.

Thanks,

Brian Donahue
Red Gate Technical Support

"gda" <oHelvetos@hotmail.com> wrote in message
news:xUhGCyS1DHA.1248@server53...
> Hi,
>
> I have just activated SQL Compare 3.1.0 and receive the following error
when
> trying to compare two databases on different servers:
>
> Index was out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index
>
> I didn't have this problem with the evaluation copy.
>
> Any ideas?
> Thanks.
>
> Daniel
>
>

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    We have uncovered a bug in the software where assigning column-level
    permissions to an AppRole on a view will cause the registration to fail
    while scripting permissions. This has been fixed and will appear in the
    upcoming version (3.1.5) of SQL Compare.

    Thanks for pointing us in the right direction on this one!

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "gda" <oHelvetos@hotmail.com> wrote in message
    news:xUhGCyS1DHA.1248@server53...
    > Hi,
    >
    > I have just activated SQL Compare 3.1.0 and receive the following error
    when
    > trying to compare two databases on different servers:
    >
    > Index was out of range. Must be non-negative and less than the size of the
    > collection. Parameter name: index
    >
    > I didn't have this problem with the evaluation copy.
    >
    > Any ideas?
    > Thanks.
    >
    > Daniel
    >
    >
This discussion has been closed.