Error on certain schema name

ShawnC3

Hello

Every time I try to select an object that has differences and the schema is "WS" (*e.g. WS.DoSomething) I get this error, and SQL Compare crashes

Index and length must refer to a location within the string.
Parameter name: length

Version 12.0.29.3182 Pro

It does not happen...
- In Version 11
- For objects that exist on one side only
- When I select all objects

Unknown:
- It applies to any of my other schemas

mattchandler

Hi Shawn,

Thanks for letting us know about this; it sounds like you've run into an important issue in SQL Compare. I have had trouble reproducing this locally though: when I tried comparing

create schema ws
go

create table ws.t
(
a int
)
go

against

create schema ws
go

create table ws.t
(
a int,
b int
)
go

I could not trigger any crashes in SQL Compare

I wonder if you could provide any more information about when you saw this crash? You could also raise an issue with support@red-gate.com if you would be more comfortable passing information on there.

Matthew Chandler
Software Developer on SQL Compare and SQL Data Compare

David E

Hi Shawn,

We fixed a very similar issue to this in 12.0.30.3199. I'd be interested to hear if this release has fixed your particular problem as well.