Just like VS Code, extensions provide more functionality to SQL Operations Studio. These extensions can come from Microsoft or the community.
Adding Extensions to SQL Operations Studio
1. Open the Extensions manager by going to the View menu and selecting Extensions. After clicking on the Extensions menu item, the Extensions navigation icon shows up on the left side. I’m not sure why this isn’t always available like it is in VS Code.
2. Browse and select an available extension. At this time there are 9 extensions available to choose from.
3. Click on the green button to install the desired extension. In my case I’m trying to install RedGate SQL Search which is a tool I use in SQL Server Management Studio. This will download the extension but if you try to double click and run it, the installation will fail. Instead you need to install it from SQL Operations Studio.
4. From SQL Operations Studio, press Ctrl/Cmd+Shift+p
, and type Extensions: Install from VSIX
and then press enter.
5. You should then see a notification in the bottom right corner of SQL Operations Studio indicating the extension has successfully been installed.
Enjoy!
References
What is Microsoft SQL Operations Studio