Azuredatastudio: [Feature Request] Keybinding Property for Connect/Change Connection in SQL Query Editor

Created on 19 Apr 2018  路  2Comments  路  Source: microsoft/azuredatastudio

As a User, I want to change my editor's database connection from the keyboard so that I can establish a connection before running a script, and/or change my connection without leaving the keyboard.

This feature would be similar to the workbench.action.editor.changeLanguageMode property. There are already "Connect" and "Change Connection" buttons in the SQL Query editor, ideally the property would extend use those functions through the following scenarios:

  1. If the editor does _not_ have a database connection established, open Recent Connections
  2. If a database connection _does_ exist, open the Recent Connections pane.
    (The same as the current results of clicking "Change Connection." Currently, if a user selects "Change Connection" and then cancels esc the Recent Connections pane, the connection is terminated. This is preferred over linking scenario 2 to disconnect.)
Area - Query Editor Enhancement

Most helpful comment

For simply changing database within the same server I'd love to have a command in the palette / a keyboard shortcut to just open up the Change database dropdown menu so I can select a different database and continue my work instead of mucking about with the connection window just to switch to a different db within the same server.
Obviously, switching to a different server is still a desirable action from the keyboard / command palette, but if you're just switching within the same server it's still a time waster.

All 2 comments

For simply changing database within the same server I'd love to have a command in the palette / a keyboard shortcut to just open up the Change database dropdown menu so I can select a different database and continue my work instead of mucking about with the connection window just to switch to a different db within the same server.
Obviously, switching to a different server is still a desirable action from the keyboard / command palette, but if you're just switching within the same server it's still a time waster.

For anyone who comes across this before it's completed in Azure Data Studio and finds themselves regularly hitting ctrl+U, here's an extension for quickly changing the database of a query editor connection.

https://github.com/dzsquared/sqlops-usedatabase

Was this page helpful?
0 / 5 - 0 ratings

Related issues

jacobzed picture jacobzed  路  3Comments

haydnlj picture haydnlj  路  3Comments

squillace picture squillace  路  3Comments

IObsequious picture IObsequious  路  3Comments

carloscfcortez picture carloscfcortez  路  3Comments