search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 906 forks source link

Export / Import Servers list #521

Open aclerbois-zz opened 6 years ago

aclerbois-zz commented 6 years ago

It's an idea for a new feature.

Allow the user to extract and export the server list in order to share with colleagues.

For example: click right on a Server group and have Export / Import menu that generate a file contains connection information (with or without password)

kburtram commented 6 years ago

This is something we've been thinking about. Most commonly people are asking for CMS integration to share connection data across a team, though we've also talked about how best to share the locally saved connection data.

Teams working on a common project using Git source control can currently share connection settings by adding the connection info to the Workspace settings, instead of the user settings. But a generic Import\Export would be useful.

aclerbois-zz commented 6 years ago

Thank you for your feedback, I hope this will be added one day, that will be useful for little team sharing connection strings

mpriesol commented 6 years ago

How about to import groups of servers from SQL Management Studio? I mean *.regsrv files. I couldn't find this option. Thank you!

sivey42 commented 5 years ago

This is something we've been thinking about. Most commonly people are asking for CMS integration to share connection data across a team, though we've also talked about how best to share the locally saved connection data.

Teams working on a common project using Git source control can currently share connection settings by adding the connection info to the Workspace settings, instead of the user settings. But a generic Import\Export would be useful.

Another scenario for this is for me as a consultant. I often am moving from one machine to another, and would love to have a way to export sections of the list and import them elsewhere. For example - at a clients office, I have all of their servers saved, but on my laptop I have folders for each client with servers below them. Being able to import/export at the folder level would make things so much easier than having to mess with the JSON and parent folder guids to try to transfer from one machine to the other.

rbharathkumar commented 4 years ago

This would be a great feature to have.... Having the ability to Export and Import connections as an XML or JSON would be most useful. I move between my remote desktops and having to configure all of the servers individually is an issue. This would be most useful.