How can we help you today? How can we help you today?

SQL Source Control 8.1.0.22472 does not work in SSMS 22

Source Control 8.1 works in SSMS 21, but in SSMS 22, it throws this error:

To use this database with SQL Source Control, you must have Team Explorer installed. This is installed with Visual Studio.

If you have Team Explorer 2013 or later, you also need to either use SQL Server Management Studio 2012 or later, or install an earlier version of Team Explorer (eg Team Explorer 2012). You don't have to uninstall Team Explorer 2013.
  at RedGate.Vcs.Common.Tfs.TfsLocation.GetOperationsFactory()
  at RedGate.Vcs.Common.Tfs.TfsLocation.GetWorkspaceCreator()
  at RedGate.SQLSourceControl.Engine.LinkedDatabase.get_WorkspaceFactory()
  at RedGate.SQLSourceControl.Engine.LinkedDatabase.GetScriptFolderWorkingBase(ICancellableOperationStatus status)
  at RedGate.SQLSourceControl.Engine.LinkedDatabase.GetDatabaseFolderWorkspaces(ICancellableOperationStatus status, SourceControlRevision& transientRevision)
  at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWayDiffSession.BuildCommon()
  at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.GetChangeSetResolvingNoOps[T](String source, IBoundDatabase boundDatabase, IChangeSetFactory`1 changeSetFactory, ICancellableOperationStatus status, SourceControlOperation sourceControlOperation)
  at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.BuildToCommitChangeSet(IBoundDatabase boundDatabase, ICancellableOperationStatus status)
  at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.<GetCancellableCommitableChanges>b__24_0(ICancellableOperationStatus status)
  at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.<>c__DisplayClass7_0.<Invoke>b__0()
  at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)
  at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)
  at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.Invoke()
  at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.RunCommitableChangesOperationThenCleanUp(ICancellableOperation`1 changes)
  at RedGate.SQLSourceControl.Engine.Utils.ErrorReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 isFatalPredicate, Boolean rethrow)

SelectStar
0

Comments

5 comments

  • Kieran Avey
    Official comment

    Hi, 


    Please could you re-install the latest version of SQL Source Control using this link?

    If this doesn't resolve the issue, please could you provide the further information requested under the support ticket?

    Kieran Avey
  • SelectStar

    I am working through a support ticket with Redgate now on this issue.  It's still not resolved, and it appears to be related to databases that are linked to a TFS (Azure DevOps) source control system.  I will update this thread when a solution is found.

    SelectStar
    0
  • Dan Birnseth

    We're bumping into this same issue trying to get Source Control working with SSMS22.  After installing v8.1.0.22472 as suggested earlier in this thread, we I see the Source Control extension but when I try to configure a database to use it, I'm met with the error below (as well as a much more detailed error report to send to Redgate, which I've sent).

    "To use this database with SQL Source Control, you must have Team Explorer installed. This is installed with Visual Studio.  

    If you have Team Explorer 2013 or later, you also need to either use SQL Server Management Studio 2012 or later, or install an earlier version of Team Explorer (eg Team Explorer 2012). You don't have to uninstall Team Explorer 2013."

    Dan Birnseth
    2
  • Thomas Scheiterbauer

    For me, as soon as i click on “Link Database”, SSMS 22 just crashes after a few seconds.

    SQLSourceControl 8.1.0.22472 (un- and then reinstall did not help)

    Thomas Scheiterbauer
    0
  • Alex

    Can confirm I'm seeing the same thing with 8.1.1.22638 and SSMS22.  It works fine with SSMS20.

    Alex
    0

Add comment

Please sign in to leave a comment.