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

Error on certain schema name

ShawnC3ShawnC3 Posts: 2
edited September 28, 2016 4:11AM in SQL Compare
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

Comments

  • Options
    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
    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
  • Options
    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.
    Software Engineer
    Redgate Software
Sign In or Register to comment.