Error: Index was out of range...

Brian Donahue

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
>
>

Brian Donahue

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
>
>