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

SQL compare slower after reloading workstation with XPSP2pro

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited October 20, 2004 1:41PM in SQL Compare Previous Versions
Hi Scott,

More than likely it's a .net Framework configuration problem. It could also be that the %TMP% folder is running low on space.


  • Options
    I found out what the problem is.

    I have also loaded SQL2005 beta 2 which uses Microsoft .Net Framework 2.0 beta. SQL Compare must use the latest and greatest version of the framework and the performance has taken a hit using 2.0 beta. I have removed the 2.0 framework and my performance has been restored to minutes instead of hours.

    I was told by our .Net guys that Red-Gate should have a config file that can be modified to tell what version of the .Net framework it should use. I did not see any type of file that I thought might control that information. Is there a way to do that?

    We are a development shop, and I am researching SQL 2005 as part of my duties, so I need to put Framework 2.0 back on my workstation so SQL 2005 can function.

    Thanks, Scott
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Scott,

    Thanks for making my job so easy! Yes, you can create a config file to redirect the assembly.

    Open Notepad and paste this text in:

    <?xml version ="1.0"?>
    <supportedRuntime version="v1.1.4322" />

    --Save this file as RedGate.SQLCompare.UI.exe.config.

    This will tell SQL Compare to use version 1.1.
This discussion has been closed.