Is Toolbelt compatible with SSMS 19?

pablolerner · February 6, 2023 11:38PM

I am trying to install SQL Toolbelt in a new computer with a fresh install of SSMS v19, but i get several warnings:

SQL Source Control 7.4

Microsoft SQL Server Management Studio (SSMS) 2012, 2014, 2016, 2017, 18 or 19 required.

[...]

SSMS integration Pack 3.1

Microsoft SQL Server Management Studio (SSMS) 2012, 2014, 2016, 17 or 18 required.

Is the SSMS Integration Pack not compatible with SSMS 19?

Why is SQL Source Control giving me a warning when SSMS 19 IS installed in the computer?

Why is SQL Toolbelt trying to install SQL Source Control 7.4 when there is version 7.5? I already have version 7.5 installed in my old computer that i am trying to replace.

Jon_Kirkwood · February 8, 2023 5:42AM

Hi @pablolerner,

Thank you for reaching out on the Redgate forums

SSMS 19 is GA already, but not all of our tools support this latest version yet.
Only SQL Prompt and SQL Change Automation work with SSMS 19 GA.

SSMS 19 Preview 2 is the only version that works with all of SQL Toolbelt Tools.

Our developers are working on the SQL Toolbelt products and we will update this post as the support for SSMS19 is rolled into the products

pablolerner · February 8, 2023 1:07PM

thanks.

jsreynolds1 · February 20, 2023 5:53PM

OMG so glad I found this. I was banging my head.

carman_houston · February 27, 2023 1:36PM

Is there any ETA when SQL Toolbelt Essentials will be fully compatible with SSMS 19?

Jon_Kirkwood · March 1, 2023 8:02AM

Hi all, just wanting to update that products are rolling out updates with SSMS19 GA support.

SQL Source Control is now supported from version v7.5.4

Download link here: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.5.4.16994.exe

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

7.5.4.16994 - February 28th, 2023

FREQUENT UPDATES RELEASE

Improvements

VT-282 - Providing support for SSMS 2019 GA.
Updated SQL Compare Engine to 15.0.5.23167

jsreynolds1 · March 1, 2023 2:17PM

Hello,

Latest 7.5.4 with SSMS19 GA support now works in 19, but I get this when opening it in the latest 18.12.1. This is from the ActivityLog.xml which was where the error pointed me to. Sorry for the giant paste; can't seem to find a way to attach a file.

<?xml version="1.0" encoding="utf-16"?>

<?xml-stylesheet type="text/xsl" href="ActivityLog.xsl"?>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>SSMS 18 version: 2019.150.18424.0</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Microsoft Visual Studio 2017 version: 15.0.28307.421</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

</entry>

<entry>

<type>Error</type>

<source>Microsoft Visual Studio Appid Stub</source>

<description>SyncLock called without an initialized synchronization object</description>

</entry>

<entry>

<type>Information</type>

<source>Microsoft Visual Studio Appid Stub</source>

<description>Application launch on system with DPI X/Y: 96/96</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Task Scheduler Package]</description>

</entry>

<entry>

<type>Information</type>

<source>Package Framework</source>

<description>Initialized ServiceProvider.GlobalProvider from SetSite.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Task Scheduler Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Error</type>

<source>Microsoft.VisualStudio.ComponentModelHost.VsShellComponentModelHost</source>

<description>Still unable to load MEF component DLL: Could not load file or assembly 'Microsoft.JSON.Core, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.</description>

<path>C:\PROGRAM FILES (X86)\MICROSOFT SQL SERVER MANAGEMENT STUDIO 18\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\OPENFOLDER\Microsoft.VisualStudio.Workspace.VSIntegration.dll</path>

</entry>

<entry>

<type>Error</type>

<source>Microsoft.VisualStudio.ComponentModelHost.VsShellComponentModelHost</source>

<description>Still unable to load MEF component DLL: Could not load file or assembly 'Microsoft.VisualStudio.Services.Client.Interactive, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.</description>

<path>C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Microsoft.VisualStudio.Shell.UI.Internal.dll</path>

</entry>

<entry>

<type>Error</type>

<source>Microsoft.VisualStudio.ComponentModelHost.VsShellComponentModelHost</source>

<description>Still unable to load MEF component DLL: Could not load file or assembly 'Microsoft.VisualStudio.ProjectSystem, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.</description>

<path>c:\program files (x86)\microsoft sql server management studio 18\common7\ide\commonextensions\microsoft\webclient\project system\Microsoft.VisualStudio.JavaScript.Project.dll</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Searching folder for extension.vsixmanifest files...</description>

<path>C:\Program Files (x86)\Common Files\Microsoft\ExtensionManager\Extensions</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Found 'C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\Microsoft\Windows Kits\10\Desktop SDK\extension.vsixmanifest'</description>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Successfully loaded extension...</description>

<path>C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\MICROSOFT\WINDOWS KITS\10\DESKTOP SDK\</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Extension is enabled...</description>

<path>C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\MICROSOFT\WINDOWS KITS\10\DESKTOP SDK\</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Found 'C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\Microsoft\Windows Kits\10\SDK ARM Additions\extension.vsixmanifest'</description>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Successfully loaded extension...</description>

<path>C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\MICROSOFT\WINDOWS KITS\10\SDK ARM ADDITIONS\</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Extension is enabled...</description>

<path>C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\MICROSOFT\WINDOWS KITS\10\SDK ARM ADDITIONS\</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Found 'C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\Microsoft\Windows Kits\10\Windows Store SDK\extension.vsixmanifest'</description>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Successfully loaded extension...</description>

<path>C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\MICROSOFT\WINDOWS KITS\10\WINDOWS STORE SDK\</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Extension is enabled...</description>

<path>C:\PROGRAM FILES (X86)\COMMON FILES\MICROSOFT\EXTENSIONMANAGER\EXTENSIONS\MICROSOFT\WINDOWS KITS\10\WINDOWS STORE SDK\</path>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Searching folder for extension.vsixmanifest files...</description>

<path>C:\Program Files (x86)\Microsoft SDKs</path>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [SqlTelemetryPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

<guid>{687B26EF-C096-4F2D-9F8C-AAAFADA321AC}</guid>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Microsoft.SqlServer.Management.SqlStudio.Explorer.SqlStudioExplorer, Microsoft.SqlServer.Management.SqlStudio.Explorer, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]</description>

<guid>{687B26EF-C096-4F2D-9F8C-AAAFADA321AC}</guid>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Windows Forms Designer Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Windows Forms Designer Package]</description>

</entry>

<entry>

<type>Information</type>

<source>Extension Manager</source>

<description>Searching folder for extension.vsixmanifest files...</description>

<path>C:\Users\john.reynolds\AppData\Local\Microsoft SDKs</path>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Microsoft.SqlServer.Management.SqlStudio.Explorer.SqlStudioExplorer, Microsoft.SqlServer.Management.SqlStudio.Explorer, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]</description>

<guid>{687B26EF-C096-4F2D-9F8C-AAAFADA321AC}</guid>

</entry>

<entry>

<type>Warning</type>

<source>CommonIDEPackage</source>

<description>About to block on async service creation because the service was requested via GetService. This has the potential to deadlock. Async initializing services should be retrieved via GetServiceAsync.</description>

</entry>

<entry>

<type>Warning</type>

<source>CommonIDEPackage</source>

<description>About to block on async service creation because the service was requested via GetService. This has the potential to deadlock. Async initializing services should be retrieved via GetServiceAsync.</description>

</entry>

<entry>

<type>Warning</type>

<source>CommonIDEPackage</source>

<description>About to block on async service creation because the service was requested via GetService. This has the potential to deadlock. Async initializing services should be retrieved via GetServiceAsync.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Appenv package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Appenv package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>ProductID: (Unavailable)</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Microsoft Data Access Version: 6.3.9600.16384</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Application Name: Microsoft SQL Server Management Studio</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>SKU Edition: Express</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Global Search Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Global Search Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>PERF: Shell start. 5173 ms</description>

</entry>

<entry>

<type>Warning</type>

<source>VisualStudio</source>

<description>Performance warning: String load failed. Pkg:{B89CD7D2-19DB-4B60-A958-E882AE71A66E} LANG:0409 ID:1006
</description>

</entry>

<entry>

<type>Error</type>

<source>FrameControlManager</source>

<description>Failed to load the frame control registered at MainWindowFrameControls\{304ee989-b7c9-46c8-aa48-f080bc47cee0}.
Exception: Microsoft.VisualStudio.PlatformUI.ControlRegistrationException: Registration error for MainWindowFrameControls\{304ee989-b7c9-46c8-aa48-f080bc47cee0} ---> System.Runtime.InteropServices.COMException: Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL))
 at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
 at Microsoft.VisualStudio.PlatformUI.FrameControl.LoadDisplayName(SettingsStore store, String collection)
 at Microsoft.VisualStudio.PlatformUI.FrameControl.Read(SettingsStore store, String collection)
 --- End of inner exception stack trace ---
 at Microsoft.VisualStudio.PlatformUI.FrameControl.Read(SettingsStore store, String collection)
 at Microsoft.VisualStudio.PlatformUI.FrameControlManager.<LoadFrameControls_OnIdle>d__7.MoveNext()</description>

</entry>

<entry>

<type>Warning</type>

<source>VisualStudio</source>

<description>Performance warning: String load failed. Pkg:{5E80A5A1-B722-4727-9015-148AAB6310B0} LANG:0409 ID:1000
</description>

</entry>

<entry>

<type>Error</type>

<source>FrameControlManager</source>

<description>Failed to load the frame control registered at MainWindowFrameControls\{73988e61-7e30-4e87-b891-23b5e460db21}.
Exception: Microsoft.VisualStudio.PlatformUI.ControlRegistrationException: Registration error for MainWindowFrameControls\{73988e61-7e30-4e87-b891-23b5e460db21} ---> System.Runtime.InteropServices.COMException: Error HRESULT E_FAIL has been returned from a call to a COM component.
 at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
 at Microsoft.VisualStudio.PlatformUI.FrameControl.LoadDisplayName(SettingsStore store, String collection)
 at Microsoft.VisualStudio.PlatformUI.FrameControl.Read(SettingsStore store, String collection)
 --- End of inner exception stack trace ---
 at Microsoft.VisualStudio.PlatformUI.FrameControl.Read(SettingsStore store, String collection)
 at Microsoft.VisualStudio.PlatformUI.FrameControlManager.<LoadFrameControls_OnIdle>d__7.MoveNext()</description>

</entry>

<entry>

<type>Warning</type>

<source>VisualStudio</source>

<description>Performance warning: String load failed. Pkg:{B22490B8-AA51-43B1-97EE-509A33B681F3} LANG:0409 ID:1001
</description>

</entry>

<entry>

<type>Error</type>

<source>FrameControlManager</source>

<description>Failed to load the frame control registered at MainWindowFrameControls\{F66FBC48-9AE4-41DC-B1AF-0D64F0F54A07}.
Exception: Microsoft.VisualStudio.PlatformUI.ControlRegistrationException: Registration error for MainWindowFrameControls\{F66FBC48-9AE4-41DC-B1AF-0D64F0F54A07} ---> System.Runtime.InteropServices.COMException: Error HRESULT E_FAIL has been returned from a call to a COM component.
 at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
 at Microsoft.VisualStudio.PlatformUI.FrameControl.LoadDisplayName(SettingsStore store, String collection)
 at Microsoft.VisualStudio.PlatformUI.FrameControl.Read(SettingsStore store, String collection)
 --- End of inner exception stack trace ---
 at Microsoft.VisualStudio.PlatformUI.FrameControl.Read(SettingsStore store, String collection)
 at Microsoft.VisualStudio.PlatformUI.FrameControlManager.<LoadFrameControls_OnIdle>d__7.MoveNext()</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {40eefa01-23fd-4980-b1d7-5f200e38567a} for UI context {e80ef1cb-6d64-4609-8faa-feacfd3bc89f} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [ComparePackage]</description>

</entry>

<entry>

<type>Information</type>

<source>Package Framework</source>

<description>Initialized ServiceProvider.GlobalProvider from SetSite.</description>

</entry>

<entry>

<type>Information</type>

<source>Package Framework</source>

<description>Initialized AsyncServiceProvider.GlobalProvider from SetSite.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [ComparePackage]</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {60e36f7b-e2e8-4683-ba39-907f57bde4a6} for UI context {e80ef1cb-6d64-4609-8faa-feacfd3bc89f} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [SQLDataGeneratorSSMSPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [SQLDataGeneratorSSMSPackage]</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {611b86b4-22e6-4945-9535-20be82383d4e} for UI context {e80ef1cb-6d64-4609-8faa-feacfd3bc89f} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [SQLDependencyTrackerSSMSPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [SQLDependencyTrackerSSMSPackage]</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {aa7202ff-562a-41af-b04d-d67f335bb1f7} for UI context {e80ef1cb-6d64-4609-8faa-feacfd3bc89f} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [SQLDocSSMSPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [SQLDocSSMSPackage]</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {e33b8a3b-d1cf-4eb0-92aa-0590f0b55b1a} for UI context {e80ef1cb-6d64-4609-8faa-feacfd3bc89f} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [SQLPromptSsmsPackage18]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Microsoft.VisualStudio.Editor.Implementation.EditorPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [File Change Manager Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [File Change Manager Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Microsoft.VisualStudio.Editor.Implementation.EditorPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [SQLPromptSsmsPackage18]</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {29d00cbc-d1f6-4f0a-9418-fc8454e3b4fe} for UI context {e80ef1cb-6d64-4609-8faa-feacfd3bc89f} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [SqlSourceControlPackage]</description>

</entry>

<entry>

<type>Error</type>

<source>VisualStudio</source>

<description>LegacySitePackage failed for package [SqlSourceControlPackage]Source: 'RedGate.SQLSourceControl.CommonUI' Description: Could not load file or assembly 'Microsoft.Data.SqlClient, Version=3.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Data.SqlClient, Version=3.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Data.SqlClient, Version=3.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5'
 at RedGate.SQLSourceControl.CommonUI.Initialization.DependencyInjectionSetup.ConfigureDatabaseConnectionFactory()
 at RedGate.SQLSourceControl.CommonUI.Initialization.DependencyInjectionSetup.SetupDependencyInjection(INinjectModule[] ssmsModules)
 at RedGate.SQLSourceControl.Extension.SqlSourceControlPackage.Initialize()
 at Microsoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
</description>

</entry>

<entry>

<type>Error</type>

<source>VisualStudio</source>

<description>SetSite failed for package [SqlSourceControlPackage](null)</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Visual Studio Solution Telemetry Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Visual Studio Solution Telemetry Package]</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {54befe64-0558-4d8c-9fd5-ab0b54733b08} for UI context {f1536ef8-92ec-443c-9ed7-fdadf150da82} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {c9dd4a57-47fb-11d2-83e7-00c04f9902c1} for UI context {f1536ef8-92ec-443c-9ed7-fdadf150da82} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Microsoft.VisualStudio.Shell.Connected.Packages.PathTrustVerifier.PathTrustVerifierPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Microsoft.VisualStudio.Shell.Connected.Packages.PathTrustVerifier.PathTrustVerifierPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Microsoft SQL Server Editors Package]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Microsoft SQL Server Editors Package]</description>

</entry>

<entry>

<type>Warning</type>

<source>AutoLoadManager</source>

<description>Package {6e87cfad-6c05-4adf-9cd7-3b7943875b7c} for UI context {adfc4e66-0397-11d1-9f4e-00a0c911004f} loads synchronously and may not be supported in a future release.</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [Microsoft.VisualStudio.PlatformUI.SolutionNavigatorPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [Microsoft.VisualStudio.PlatformUI.SolutionNavigatorPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [ProviderPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [ProviderPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Entering function CVsPackageInfo::HrInstantiatePackage</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [RadLangSvc.Package, RadLangSvc, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>End package load [RadLangSvc.Package, RadLangSvc, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]</description>

</entry>

<entry>

<type>Information</type>

<source>MruList</source>

<description>Entering AddItem. Persistence data for item: C:\Users\john.reynolds\AppData\Local\Temp\~vsAABA.sql|00000000-0000-0000-0000-000000000000|0,0</description>

</entry>

<entry>

<type>Information</type>

<source>MruList</source>

<description>Entering AddItem. Persistence data for item: C:\Users\john.reynolds\AppData\Local\Temp\~vsB29B.sql|00000000-0000-0000-0000-000000000000|0,0</description>

</entry>

<entry>

<type>Information</type>

<source>MruList</source>

<description>Entering AddItem. Persistence data for item: C:\Users\john.reynolds\AppData\Local\Temp\~vsB56B.sql|00000000-0000-0000-0000-000000000000|0,0</description>

</entry>

<entry>

<type>Error</type>

<source>VisualStudio</source>

<description>End package load [SqlSourceControlPackage]</description>

</entry>

</activity>

DROP_TABLE_Students · March 1, 2023 2:36PM

Thanks @Jon_Kirkwood. But I concur with @jsreynolds1, it works in 19.0.1, but not in 18.12.1.

Jon_Kirkwood · March 7, 2023 6:37AM

Hi all,

Our product experts have reported a few instances of products not working in SSMS18 after patching the latest versions. This is found where users have multiple SSMS instances (e.g. 18 & 19)

If you are still finding issues with programs not working in SSMS18 can you please conduct a complete uninstall/reinstall of the affected tools.

---
Also a quick update on tools now supporting SSMS19

SQL Prompt - v10.13.5
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.5.16.exe

SQL Source Control - v7.5.4
https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.5.4.16994.exe

SQL Search - v3.6.1
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe

SQL Doc - v5.2.6
https://download.red-gate.com/checkforupdates/SQLDoc/SQLDoc_5.2.6.3425.exe

SQL Test - v4.1.4
https://download.red-gate.com/checkforupdates/SQLTest/SQLTest_4.1.4.2200.exe

The Toolbelt Installer has not been updated with these versions, so at present we suggest using the individual installers to get products updated.

Esc · June 2, 2023 12:08AM

My SQL Compare still does not support SSMS 19 as the SQL editor as of version 15.0.7.23280

Image: https://us.v-cdn.net/6029854/uploads/editor/j8/j05x3vxpe80c.png

Richard Line · June 9, 2023 1:30PM

I have the same issue as @jsreynolds1, I have installed the lastest release of SSMS 19, uninstalled all redgate tools and reinstalled. Then rebooted. I then get

Image: https://us.v-cdn.net/6029854/uploads/editor/5x/bd6l3xwodc6j.png

Check the log it looks like it can't find files in the SSMS 19 install folder, but they are all there. Is it a permissions issue for the installer? I have been able to get the same issue on all of our developers' installs.

Richard Line · June 9, 2023 1:33PM

Also have the same issue as @Esc in SQL Compare 15

DBAJohnny · June 10, 2023 1:00PM

I installed SSMS 19 this morning and downloaded and installed the latest version of SQL Toolbelt Essentials. I'm getting the same error message ("The 'SQLSourceControlPackage' did not load correctly") when going into SSMS.

I uninstalled SSMS 18, SSMS 19 and SQL Toolbelt, rebooted, reinstalled. No difference.

I need to get SQL Source control working. Please advise, and thanks!

The affected section of the ActivityLog.xml file is:

<entry>

<type>Warning</type>

<source>VisualStudio</source>

<description>Unexpected system error mode before loading package [SqlSourceControlPackage]</description>

</entry>

<entry>

<type>Information</type>

<source>VisualStudio</source>

<description>Begin package load [SqlSourceControlPackage]</description>

</entry>

<entry>

<type>Error</type>

<source>VisualStudio</source>

<description>CreateInstance failed for package [SqlSourceControlPackage]Source: 'mscorlib' Description: Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
 at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
 at RedGate.SQLSourceControl.Extension.SqlSourceControlPackage..ctor()
 --- End of inner exception stack trace ---
 at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
 at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
 at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
 at System.Activator.CreateInstance(Type type, Boolean nonPublic)
 at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
 at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
 at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
 at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
 at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
 at RedGate.SQLSourceControl.Extension.SqlSourceControlPackage..ctor()</description>

</entry>

DBAJohnny · June 12, 2023 3:18PM

I've started a specific question for the SQL Compare plugin on SSMS 19. See https://forum.red-gate.com/discussion/89890/i-am-unable-to-get-the-sql-compare-plugin-working-with-ssms-19/p1?new=1

chrisqtran · June 12, 2023 5:20PM

Hi all,

For the SQL Data Compare/Compare - SSMS SQL Editor issue, this should be resolved in the latest installers. I've linked them here:
SQL Compare
SQL Data Compare

For the SQL Source Control issue, this installer should resolve the error message:
SQL Source Control

Dan_J · June 13, 2023 6:34AM

Hi @Esc & @Richard Line,

Regarding SSMS 19 not being selectable as a SQL editor, this was resolved in the latest version of SQL Compare and SQL Data Compare. The download URL's for both products are below:

SQL Compare: https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.0.9.23488.exe

SQL Data Compare: https://download.red-gate.com/checkforupdates/SQLDataCompare/SQLDataCompare_15.0.9.23488.exe

I hope this helps!

Richard Line · June 13, 2023 7:14AM

Hi, I need to roll this out to our development team, when will these be part of the main installer?

Dan_J · June 13, 2023 2:01PM

Hi Richard,

We have reached out to our development team regarding getting the main Toolbelt installer updated with the very latest versions of SQL Source Control, SQL Compare and SQL Data Compare. We will come back to you as soon as this has been completed.

Dan_J · June 16, 2023 10:07AM

Hi Richard,

I'm pleased to advise that the main Toolbelt installer now contains the latest versions of SQL Compare and SQL Data Compare.

Is Toolbelt compatible with SSMS 19?

Best Answer

Answers

7.5.4.16994 - February 28th, 2023

FREQUENT UPDATES RELEASE

Improvements

Product Learning

Community Forums

Events & Friends

Simple Talk