Options
TFS Link Not Working
VBJV
Posts: 13 Bronze 2
in SQL Compare
We have SQL Source Control (7.2.11.11679) linked to our Team Foundation Server (TFS) 2018 instance and it is working fine. However, when we try to deploy FROM TFS using SQL Compare, it is telling us that we do not have the required software installed. This a new error / condition that has showed up since installing the latest SQL Compare version (14.4.4.16824). Prior to updating, this error was not present and everything worked fine. I am on a Windows 10 (20H2 Build 19042.685) machine with Visual Studio 2019 (16.8.3) and SQL Server Management Studio (18.5.1) installed. Our workaround is to Compare/Deploy from a Dev/QA server instance to a Production server instance instead of TFS -> Production. This is not an ideal situation for us and we would appreciate any and all assistance.
Tagged:
Best Answers
-
Options
DanC
Posts: 591 Gold 4
Hi @VBJV
Sorry, you're experiencing this issue!
So this is a recent bug with SQL Compare using the integration of SQL Source Control connecting to TFS, the team is currently investigating the issue with the following reference: SOC-10208
The current workaround I suggest is rather than selecting SQL Source Control as the Source or Target in SQL Compare, is to select a Scripts folder and reference the local copy of the repository.
Version 7.1.19 of SQL Source Control works with SQL Compare to connect directly to TFS, however, you may hit old bugs with the older SQL Source Control version.
I'll link the version here if it makes life a little easier, but I would air on the side of caution, and if the workaround is sufficient, I recommend sticking with that for now.
https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.1.19.10595.exe
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center? -
OptionsDanC
Posts: 591 Gold 4
Hi @VBJV
I'm pleased to inform you that the latest update to SQL Source Control now has the fix for the TFS issue!- SOC-10208 - Fixed issue that prevented connections to TFS projects in SQL Compare
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers
Thanks for getting back to me and letting me know that a fix has been posted. I was able to download/install the new version. I can confirm that everything is looking much better on my end. The error does indeed appear to be resolved.
You're most welcome, I'm pleased to hear the new update fixed the issue for you!
If you come across any other issues or have any questions, don't hesitate to get in contact with us on support.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?