יונ14

Written by: ronen ariely
14/06/2022 00:36 

Introduction

Following my lecture at the .Net conference, about how to develop extensions to SQL Server Management studio, you can download the code and compiled package here.

This is small add-in for SSMS in order to work with JSON and actually be able to read the JSON code. It has a "pretty JSON" functionality amount other tools.

Note! Unfortunately the TechNet wiki code was closed a few years ago and other options like OneDrive does not allow to add a short explanation, and since I do not expect many downloads (I only presented this link during my session at the .Net event), so this time, I will use This location to allow directly download the file/project. This might be changed in the future.

UPDATE 2023-03-20 02:24 I am going to upload the source package to OneDrive, since I have just publish this download for the MVP activities in public. This means That multiple people might downlead the files now. The complied package is still directly downloaded from my site.

Note: This is a small extension for SSMS which provide some nice tool. I am using it (one version or another) from 2015 when the support to JSON was added to SQL Server 2016. The extension is packed as a VSIX file.

* A VSIX package is a .vsix file that contains one or more Visual Studio extensions and the metadata that Visual Studio uses to classify and install the extensions. SSMS is based on Visual Studio and using VSIX is one option to add extensions to SSMS.

   

Supported (on your own responsibility!)

• The complied file was tested on SSMS version 2014, 2016,17,18, 19. 
• It should work on VS 2015, 2017 (we get alert but works), but not supported in VS 2019

  

installing

Using SSMS 13, 14 you can simply run the VSIX file. You should get a window with option to install it in any visual studio or SSMS which are installed on your machine and are supported the automatic installation of the extension (this extension supported on VS and SSMS).

Using SSMS 15 and above, you need to copy the files in the extension folder, to the location of the extensions of the installed SSMS. By default it should be at:

C:\Program Files (x86)\Microsoft SQL Server Management Studio <18/19>\Common7\IDE\Extensions\Ariely_VSIX_SSMS

If you want to compile the file or get more information about installing on SSMS 18 and above: https://learn.microsoft.com/en-us/sql/ssms/install-extensions-in-sql-server-management-studio-ssms?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699

  

How to use it?

The extension works on the editor window. When you run a query which return JSON then click the JSON link in order to open in a new window. The JSON will be in one unreadable line. Click the extension to make the JSON text looks pretty.

  

Downlow

Download my SSMS Extension VSIX Package Compiled (this is a zip file. You can change the extension from .zip to .vsix if you want to install it on older version by double click, but on SSMS 18.x and above you cannot use the .vsix file but simply unzip and copy the folder to the extensions folder of the SSMS)

Download the code (VS project)