I like the new UI for SQL Compare. It is much better than the previous one. I have used the software a few times now, and have some comments.

Firstly the software has difficulty with larger font-sizes in the OS. Because of my screen resolution (1920x1200) I have increased the display DPI settings to 110% to make text more readable. Most software recognizes this and scales accordingly. In SQL Compare however some text in certain screens become very diificult to read because it scrolls of the page or line. See the sample below. This happens in more forms.
redgate1.gif

Secondly I received an error message when comparing two of my databases: "Index was outside the bounds of the array".
redgate2.gif

I have copy-pasted the complete error message below for your reference.

I hope this helps.

Erik

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at _8._1(Int64 , Byte )
   at _114._1(Difference , Regions , Regions )
   at _94._3()
   at _94._1(Difference )
   at _92._1(Object , _73 )
   at _72._1(Difference )
   at _72._4(Object , MouseEventArgs )
   at DevExpress.XtraGrid.Views.Base.BaseView.RaiseMouseUp(MouseEventArgs e)
   at DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnMouseUp(MouseEventArgs ev)
   at DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args)
   at DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args)
   at DevExpress.XtraGrid.GridControl.OnMouseUp(MouseEventArgs ev)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
   at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
RedGate.SQLCompare.UI
    Assembly Version: 5.0.0.1288
    Win32 Version: 5.0.0.1288
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.UI.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
RedGate.SQL.Shared
    Assembly Version: 5.1.0.52
    Win32 Version: 5.1.0.52
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQL.Shared.DLL
----------------------------------------
System.Drawing
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
RedGate.SQLCompare.Engine
    Assembly Version: 5.0.0.1288
    Win32 Version: 5.0.0.1288
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.Engine.DLL
----------------------------------------
ActiproSoftware.UIStudio.Dock
    Assembly Version: 2.0.61.0
    Win32 Version: 2.0.61.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.UIStudio.Dock.DLL
----------------------------------------
ActiproSoftware.Shared
    Assembly Version: 1.0.76.0
    Win32 Version: 1.0.76.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.Shared.DLL
----------------------------------------
ActiproSoftware.WinUICore
    Assembly Version: 1.0.76.0
    Win32 Version: 1.0.76.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.WinUICore.DLL
----------------------------------------
DevExpress.XtraBars3
    Assembly Version: 3.6.0.0
    Win32 Version: 3.6.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraBars3.DLL
----------------------------------------
DevExpress.XtraEditors3
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraEditors3.DLL
----------------------------------------
DevExpress.Utils3
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Utils3.DLL
----------------------------------------
System.Design
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.design/1.0.5000.0__b03f5f7f11d50a3a/system.design.dll
----------------------------------------
DevExpress.XtraPrinting3
    Assembly Version: 1.11.0.0
    Win32 Version: 1.11.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraPrinting3.DLL
----------------------------------------
DevExpress.XtraGrid3
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraGrid3.DLL
----------------------------------------
DevExpress.Data3
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Data3.DLL
----------------------------------------
System.Data
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
RedGate.SQL.Controls
    Assembly Version: 5.1.0.52
    Win32 Version: 5.1.0.52
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQL.Controls.DLL
----------------------------------------
System.Xml
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
RedGate.Update.Client
    Assembly Version: 1.1.0.33
    Win32 Version: 1.1.0.33
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Update.Client.DLL
----------------------------------------
Accessibility
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.573
    CodeBase: file:///c:/windows/assembly/gac/accessibility/1.0.5000.0__b03f5f7f11d50a3a/accessibility.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.dll
----------------------------------------
XtraDataTempAssembly
    Assembly Version: 0.0.0.0
    Win32 Version: n/a
    CodeBase: 
----------------------------------------
System.Web.Services
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system.web.services/1.0.5000.0__b03f5f7f11d50a3a/system.web.services.dll
----------------------------------------
System.Web
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2037
    CodeBase: file:///c:/windows/assembly/gac/system.web/1.0.5000.0__b03f5f7f11d50a3a/system.web.dll
----------------------------------------
d4dpvxaq
    Assembly Version: 0.0.0.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.
[/img]
erossou
0

Comments

6 comments

  • Tom Harris
    Hi there,

    could you instll the RC1 of SQL Bundle 5. We hope that we have fixed the crash that you are getting when you try and compare 2 databases. I'm afraid we have not been able to change how the UI behaves when you modify the DPI setting.

    Thanks,

    Tom
    Tom Harris
    0
  • erossou
    Hi Tom,

    Thanks for your reply. I'll download RC1 and try again.

    Erik
    erossou
    0
  • erossou
    Hi Tom,

    I've downloaded and installed RC1 but I am sorry to say the bug is still there. It gives the error below when I compare the same two databases as in the first try a few days ago.

    Hope this helps to nail down the problem.

    Erik

    See the end of this message for details on invoking 
    just-in-time (JIT) debugging instead of this dialog box.
    
    ************** Exception Text **************
    System.IndexOutOfRangeException: Index was outside the bounds of the array.
       at _8._1(Int64 , Byte )
       at _115._1(Difference , Regions , Regions )
       at _94._4()
       at _94._1(Difference )
       at _92._1(Object , _71 )
       at _70._1(Difference )
       at _70._4(Object , MouseEventArgs )
       at DevExpress.XtraGrid.Views.Base.BaseView.RaiseMouseUp(MouseEventArgs e)
       at DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnMouseUp(MouseEventArgs ev)
       at DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args)
       at DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args)
       at DevExpress.XtraGrid.GridControl.OnMouseUp(MouseEventArgs ev)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
       at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    
    
    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
    ----------------------------------------
    RedGate.SQLCompare.UI
        Assembly Version: 5.0.0.1559
        Win32 Version: 5.0.0.1559
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.UI.exe
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
    ----------------------------------------
    System
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
    ----------------------------------------
    RedGate.SQL.Shared
        Assembly Version: 5.1.0.84
        Win32 Version: 5.1.0.84
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQL.Shared.DLL
    ----------------------------------------
    System.Drawing
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
    ----------------------------------------
    RedGate.Licensing.Client
        Assembly Version: 1.3.0.21
        Win32 Version: 1.3.0.21
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Licensing.Client.DLL
    ----------------------------------------
    RedGate.SQLCompare.Engine
        Assembly Version: 5.0.0.1559
        Win32 Version: 5.0.0.1559
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.Engine.DLL
    ----------------------------------------
    System.Xml
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
    ----------------------------------------
    RedGate.Licensing.Helper
        Assembly Version: 1.3.0.21
        Win32 Version: 1.3.0.21
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Licensing.Helper.DLL
    ----------------------------------------
    ActiproSoftware.UIStudio.Dock
        Assembly Version: 2.0.61.0
        Win32 Version: 2.0.61.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.UIStudio.Dock.DLL
    ----------------------------------------
    ActiproSoftware.Shared
        Assembly Version: 1.0.76.0
        Win32 Version: 1.0.76.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.Shared.DLL
    ----------------------------------------
    ActiproSoftware.WinUICore
        Assembly Version: 1.0.76.0
        Win32 Version: 1.0.76.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.WinUICore.DLL
    ----------------------------------------
    DevExpress.XtraBars3
        Assembly Version: 3.7.4.0
        Win32 Version: 3.7.4.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraBars3.DLL
    ----------------------------------------
    DevExpress.XtraEditors3
        Assembly Version: 3.2.4.0
        Win32 Version: 3.2.4.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraEditors3.DLL
    ----------------------------------------
    DevExpress.Utils3
        Assembly Version: 3.2.4.0
        Win32 Version: 3.2.4.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Utils3.DLL
    ----------------------------------------
    System.Design
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/assembly/gac/system.design/1.0.5000.0__b03f5f7f11d50a3a/system.design.dll
    ----------------------------------------
    DevExpress.XtraPrinting3
        Assembly Version: 1.12.4.0
        Win32 Version: 1.12.4.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraPrinting3.DLL
    ----------------------------------------
    DevExpress.XtraGrid3
        Assembly Version: 3.2.4.0
        Win32 Version: 3.2.4.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraGrid3.DLL
    ----------------------------------------
    DevExpress.Data3
        Assembly Version: 3.2.4.0
        Win32 Version: 3.2.4.0
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Data3.DLL
    ----------------------------------------
    System.Data
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
    ----------------------------------------
    RedGate.SQL.Controls
        Assembly Version: 5.1.0.84
        Win32 Version: 5.1.0.84
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQL.Controls.DLL
    ----------------------------------------
    Accessibility
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/assembly/gac/accessibility/1.0.5000.0__b03f5f7f11d50a3a/accessibility.dll
    ----------------------------------------
    RedGate.Update.Client
        Assembly Version: 1.2.0.3
        Win32 Version: 1.2.0.3
        CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Update.Client.DLL
    ----------------------------------------
    System.EnterpriseServices
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.2032
        CodeBase: file:///c:/windows/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.dll
    ----------------------------------------
    XtraDataTempAssembly
        Assembly Version: 0.0.0.0
        Win32 Version: n/a
        CodeBase: 
    ----------------------------------------
    
    ************** JIT Debugging **************
    To enable just in time (JIT) debugging, the config file for this
    application or machine (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.
    
    For example:
    
    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>
    
    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the machine
    rather than being handled by this dialog.
    
    erossou
    0
  • James Moore
    Hi Erik,

    Thanks for retrying that.

    We have now resolved the issue in our internal builds (It was related to our syntax highlighting with large objects which are different but exist in both databases).

    We will post another RC in the next few days and if you could give it a try again with the next RC it would be very much appreciated.

    Many thanks

    - James
    --
    James Moore
    Red Gate Software Ltd
    James Moore
    0
  • erossou
    Hi James,

    I will try with the new build as soon as it is available.

    Erik
    erossou
    0
  • erossou
    I have downloaded and installed RC2. With this new build I am not able to reproduce the bug, so you seem to have it fixed.

    Thanks,

    Erik
    erossou
    0

Add comment

Please sign in to leave a comment.