[Solved] Will a version of the SSMS plugin for SSMS 20 be released?

4 Posts
2 Users
0 Reactions
359 Views
(@agwillow)
Member
Joined: 7 months ago
Posts: 3
Topic starter  

Will a version of SQLinForm for SSMS 20 be available anytime soon? Can the version for SSMS 19 somehow be used for SSMS 20?


   
Quote
Topic Tags
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 216
 

You can install the SSMS20 Plugin Beta Version as follows:

  1. Download the SQLinForm Formatter Bundle from
    https://www.sqlinform.com/download-sql-formatter-windows-app/
  2. Unzip the downloaded zip file into to a dir of your choice (e.g. C:\SQLinFormDesktop)
  3. Copy the included folder SSMSPlugin to C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions
  4. Start SSMS and goto Tools > Options > SQLinForm and specify the Folder where you unzipped the downloaded file. With this information the Plugin can find the formatting profiles. Without this info it takes the default profile which very probably will not be your perfect choice.
  5. The formatting Profiles can now be adapted using the Windows Desktop App.
    You can start the Desktop app:
    * double-click the .exe in the unzipped folder.
    * or you can call the Desktop App from within SSMS20 using “External Command”
        

 

You can format your SQL using the SQLinFormCommands

 

 

Please let me know your thoughts.

Regards

Guido


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 216
 

If you get an error on the Option Panel then

please go to the copied folder and please right-click on the SQLinFormVSIX.dll file . and select “Properties”. On the General tab, please click on the Unblock button to indicate that this assembly is trusted.

 

Regards

Guido


   
ReplyQuote
(@agwillow)
Member
Joined: 7 months ago
Posts: 3
Topic starter  

That did it. Thanks for the quick reply!


   
ReplyQuote
Share: