I am unable to get the SQL Compare plugin working with SSMS 19
DBAJohnny
Posts: 30 Bronze 2
I originally posted this as a comment on https://forum.red-gate.com/discussion/89594/is-toolbelt-compatible-with-ssms-19, but I'm starting a new thread as the rest of toolbelt seems to be working.
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!
From the ActivityLog.xml file, it seems that the inner exception is a "key not found" error:
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!
From the ActivityLog.xml file, it seems that the inner exception is a "key not found" error:
<entry>
<record>263</record>
<time>2023/06/12 12:46:44.792</time>
<type>Information</type>
<source>VisualStudio</source>
<description>Begin package load [SqlSourceControlPackage]</description>
<guid>{29D00CBC-D1F6-4F0A-9418-FC8454E3B4FE}</guid>
</entry>
<entry>
<record>264</record>
<time>2023/06/12 12:46:45.089</time>
<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>
<guid>{29D00CBC-D1F6-4F0A-9418-FC8454E3B4FE}</guid>
<hr>80004005 - E_FAIL</hr>
<errorinfo></errorinfo>
</entry>
Tagged:
Best Answer
-
chrisqtran
Posts: 121 Silver 3
Hi there @DBAJohnny
Can you try installing this version and see if it resolves your issue?
https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.6.11.17356.exe
Answers
Thanks for the quick response!