TFS Link Not Working

VBJV

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.

DanC

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

DanC

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

https://documentation.red-gate.com/soc/release-notes-and-other-versions/sql-source-control-7-2-release-notes

VBJV

@DanC
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.  

DanC

Hi @VBJV

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.