SQL compare slower after reloading workstation with XPSP2pro

Brian Donahue

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.

Scott Tucholka

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

Brian Donahue

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"?>
<configuration>
<startup>
<supportedRuntime version="v1.1.4322" />
</startup>
</configuration>

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

This will tell SQL Compare to use version 1.1.