SQL DataCompare toolbar button grayed out

tkdennis

What would cause the button to be unavailable? I have two databases I just finished synchronizing with SQL Compare, but the SQL DataCompare button is not available. I can exit SQL Compare, open SQL DataCompare, open the SQL Compare project and do the data compare fine. The SQL Compare button is available when I start from SQL DataCompare.

Thanks,
Traci
SQL Compare 8.1.0.360
SQL DataCompare 8.1.1.39

chriskelly

The following forum post details a cumulative patch that should solve your problem:

http://www.red-gate.com/messageboard/vi ... hp?t=11077

tkdennis

I installed the cumulative patch and the SQL Data Compare launch button is still grayed out. I tried an existing project and creating a new project.

Thanks.
Traci
SQL Compare 8.2.1.49

tkdennis

I'm still having this problem even on the latest cumulative patch.



Thanks,
Traci

dsp

Any news about this annoying bug? We have it at several computers, Sql Compare Professional version 9.0.0.79. It sometimes works from Sql Data Compare to Sql Compare, but the other way never.

Brian Donahue

I'm sure the patch suggested above prevents the problem from happening in the future, but I'm not sure if it actually fixes it. The problem was a duplicate registry key left behind by a previous version of SQL/Data Compare. Try deleting the eldest subkey in

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQLToolsInstalledProducts\SQL Data Compare

For instance, if you do not have v8 installed, delete the "8.0" subkey.

dsp

Cool, That solved my problem.

Thank you,
Danny Springer