Give option to connect to multiple databases from the same server
When we add database connections to a query, it is always a specific database connection. Instead, if there is an option to add the connection at the server level to the query and the user can query from different databases that are existing on the same server, then that would be amazing. Right now, I have to do this by connecting to various databases from different query windows, each one linking to a specific database, which is not user-friendly and error-prone.
6
votes
Pavan Dabbugottu
shared this idea
-
MB
commented
You can do something like this by holding ctrl and dragging a db into the query window. It will create a sort of combined data source.