Comparing against a named instance

paulhpaulh Posts: 35 Bronze 2
edited September 26, 2007 1:23PM in SQL Data Compare Previous Versions
The series 5 products (Compare/Data Compare) don't appear to be able to compare against an instance of a server on a box, e.g. MYSERVER\2005.

Checked in Compare 6.0 and this works.

Is this a known bug and is it likely to be fixed in a V5 release?

Thanks

Paul

Comments

  • Hi,

    You certainly should be able to - I wonder if you could give some more details of the error you're seeing, and what (minor) version of Data Compare you're running?

    Thanks,
    Robert
    Robert Chipperfield
    Red Gate
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Paul,

    The difference may well be the version of .NET that v5 was built against, which was 1.1. Version 6 uses the 2.0 runtime, which seemed to solve a lot of the connection issues in the ADO .NET SQL Client. Editing the RedGate.SQLDataCompare.UI.exe.config file to use only the 2.0 runtime may help.

    If this issue is actually the detection of SQL Servers on the network, the fact is that version 6 does a better job of it. That said, there is nothing stopping you from typing the server name in manually.
  • paulhpaulh Posts: 35 Bronze 2
    I am typing in the server name, or rather then IP address, manually.

    The only protocol open is TCP/IP, and on Compare 5 it says it can't find the database whereas Compare 6 works fine.

    Problem is, now that I've sync'd the schemas I'd like to move the data as well :)
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Here are the instructions to make Data Compare 5 use the .NET 2.0 runtime. It may help.

    http://www.red-gate.com/support/kb/KB200703000015.htm
  • paulhpaulh Posts: 35 Bronze 2
    Thanks Brian, I'll try that and let you know how I get on

    Paul
  • paulhpaulh Posts: 35 Bronze 2
    Brian

    I followed the suggestion in the KB article; the config files already existed and contained two lines

    <supportedRuntime version="v1.1.4322"/>
    <supportedRuntime version="v2.0.50727"/>

    If I remove the v1.1 line, the application fails to start; this is true for both Compare and Data Compare
  • Don't know what to tell you... version 5.3 should run in .NET 2.0's runtime.
  • What is the error message?
  • paulhpaulh Posts: 35 Bronze 2
    Brian

    There's a type instantiation failure from one of the DevExpress DataGrid components.

    I tried uninstalling everything and re-installing it, and now I get an error "The type initializer for '_123' threw an exception.

    Works ok on another machine, but I can't see any differences between them.
  • Hi Paul,

    Thanks for pointing this out. There is a known issue with DevExpress as they have a .NET 2 version of their component which has the same version and key signature as the 1.1 version used in Data Compare. This means if some other program installs the DevExpress 2.0 stuff in the GAC (%systemroot%\assembly), Data Compare loads these and blows up.

    The fix is a two-parter: figure out which application installed these (probably NUnit) and move them out of the GAC and into that program's local folders.
  • paulhpaulh Posts: 35 Bronze 2
    Brian

    Thanks for that - I unregistered the DevExpress controls from the GAC and it worked fine.

    Paul
  • Hi Paul,

    Thanks for getting back. In SQL Compare 6 and future versions of SQL tools, I think this DevExpress issue has been worked around. At any rate, newer versions of the software are built against the 2.0 runtime, so these DevExpress components being in the GAC wouldn't cause an issue.

    Thanks for your patience on this one!
  • paulhpaulh Posts: 35 Bronze 2
    Brian

    No problem, just glad we could resolve it in the end.
Sign In or Register to comment.