10

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.

bubbleking
  • 3,329
  • 3
  • 29
  • 49
Craig Boland
  • 984
  • 1
  • 10
  • 18

2 Answers2

11

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 and paste them into his user settings except the password. Everyone needs to add that individually after the fact. I would suggest creating a JSON file with those settings and adding the steps to a readme.md file. enter image description here

bubbleking
  • 3,329
  • 3
  • 29
  • 49
Mohamed Sahbi
  • 1,065
  • 10
  • 24
8

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
Rider Harrison
  • 441
  • 6
  • 12