Any way to browse all sql server database objects on a server/instance?
We have multiple databases in a system (10+), and its a bit onerous to connect to each individually
I'd like to browse like in SSMS Object Explorer. It would save me lots of time
Please sign in to leave a comment.
I'm just another user, not a JetBrains rep. This has been requested in the past. This really is a case of, "Becareful what you wish for, because you just might get it." I work in environments similar to what you shown, where you have multiple databases you want to spin up all at once.
The problem is when you have a dozen databases where each has 10+ schemas and each schema has as 200+ tables. You will be waiting forever for DataGrip to index everything. I've done that once just for giggles. Clicked each database, clicked all schemas, and pressed [enter]. Hours later DataGrip was still spinning the wheel.
What I do now is create individual projects that have my datasources, databases, and schemas configured. It takes just a little time to click through and select what is truly wanted.
Just saying.
Yes, you don't need to connect individually, just choose databases you need in the data source properties. Or, in 2017.3, just Alt+Enter → Manage shown schemas...