Home Professional Edition Commands Extensions SSMS Resources What's New

Visual Commander Visual Commander

SSMS

SSMS 21+

1. SSMS 21+ supports .vsix installers and you can use the main Visual Commander installer file:

2. In the main SSMS menu Extensions - Customize Menu... uncheck the VCmd entry:

SSMS main menu customization

Click Save and Restart.

3. Visual Commander is ready to use:

Visual Commander menu in SSMS

About command

Date command

SSMS 18

SSMS 18 doesn't support .vsix installers, but you can install Visual Commander manually:

1. Unzip VisualCommanderSSMS_26.vsix to the following directory:

%LocalAppData%\Microsoft\SQL Server Management Studio\18.0_IsoShell\Extensions\VisualCommanderSSMS

2. Change in the following text the directory to the one used in step 1, save the text as a .reg file and execute:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\18.0_IsoShell\ExtensionManager\EnabledExtensions]
"e4b1fd83-b59d-41ca-a21d-19b10230ece5,2.6.0"="C:\\Users\\[your_name]\\AppData\\Local\\Microsoft\\SQL Server Management Studio\\18.0_IsoShell\\Extensions\\VisualCommanderSSMS\\"

[HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\18.0_IsoShell\ExtensionManager\ExtensionTypes]
"e4b1fd83-b59d-41ca-a21d-19b10230ece5,2.6.0"="Tool"

[HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\18.0_IsoShell\ExtensionManager\ExtensionAutoUpdateEnrollment]
"e4b1fd83-b59d-41ca-a21d-19b10230ece5,2.6.0"="1"

3. You may also need to install Visual Studio 2015 Isolated Shell.

SSMS 2016, 17

Visual Commander supports SQL Server Management Studio 2016 (July v13.0.15500.91 and newer releases) and SQL Server Management Studio 17:

Visual Commander menu in SSMS 2016

Visual Commander for SSMS v2.6 - May 19, 2017. Download Now

Uninstall

As there is no extension manager in SSMS, you can use the following command to uninstall Visual Commander:

C#
References: Microsoft.VisualStudio.ExtensionManager

public class C : VisualCommanderExt.ICommand
{
    public void Run(EnvDTE80.DTE2 DTE, Microsoft.VisualStudio.Shell.Package package) 
    {
        System.IServiceProvider serviceProvider = package as System.IServiceProvider;
        Microsoft.VisualStudio.ExtensionManager.IVsExtensionManager em =
           (Microsoft.VisualStudio.ExtensionManager.IVsExtensionManager)serviceProvider.GetService(
                typeof(Microsoft.VisualStudio.ExtensionManager.SVsExtensionManager));
	
        Microsoft.VisualStudio.ExtensionManager.IInstalledExtension vcmd = 
            em.GetInstalledExtension("e4b1fd83-b59d-41ca-a21d-19b10230ece5");
        em.Uninstall(vcmd);
        System.Windows.MessageBox.Show(vcmd.Header.Name + " has been uninstalled.");
    }
}