'How to export Server Group configurations?

How can I export to file my Server Group configurations in Azure Data Studio?

I've created a Workspace file in my application solution that contains useful queries for troubleshooting, etc. I'd like to also include connection configurations for servers relevant to the solution so that any developer can use the Workspace queries quickly without having to ask which servers to run them on.



Solution 1:[1]

You can copy your Server Group configurations from User Settings. You will find them under datasource.connectionGroups and connection details under datasource.connections (if you have different ones, check with the group id). Any user can copy paste them into his user settings except the password. Everyone needs to add it after that. I would suggest to create a JSON file with those settings and add the steps to readme.md file. enter image description here

Solution 2:[2]

All connections and groups are located in the settings.json file located at:

%AppData%\azuredatastudio\User\

For me specifically the path looked like this:

C:\Users\MyLogin123\AppData\Roaming\azuredatastudio\User

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mohamed Sahbi
Solution 2 Rider Harrison