0

i have created an extension and now i have to install it in the different targets as Visual Studio, SSMS. I have enabled the version also in install targets:

enter image description here

At first when i install this it is successfully installed on Visual studio and second thing it is unable to find the SSMS to install this extension.

I have gone through this article and perform the command line installation:

enter image description here

but no luck. Please suggest.

Community
  • 1
  • 1
Nimit Joshi
  • 1,026
  • 3
  • 19
  • 46

1 Answers1

0

Issue occured during extension installation for SSMS

Actually, installing an extension in SSMS is not the same as VS IDE. I suggest you could follow these steps:

1) Right-click on the vsix project-->Properties-->Debug-->and then change Start External program into the path of SSMS installation path like this:

C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe

enter image description here

Besides, under that window, you should remove the command line arguments.

enter image description here

2) create a custom folder called VSIXProject under C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions

Then, Set Deploy VSIX to SSMS:

Right-click on project-->VSIX-->check option Copy VSIX content to the following location and then input C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\VSIXProject

enter image description here

3) Run VS as administrator and you can debug this project which debug in SSMS and when you finish debugging it. The extension will automatically installed into SSMS.

In addition, you can refer to this issue.

Mr Qian
  • 21,064
  • 1
  • 31
  • 41