Help: SQL Server doesn't work on whole instance

I can connect to SQL Server with native or jdbc driver and it lets me explore object in that one database, but for an instance that has many databases, it would be nice to see explore those objects too.

 

In the data source definition if I leave the database field blank, it connects me to master.  If I fill the field with a db name, it connects me to that one db only.  I can't see any other database objects.  

 

Is this intended or is something wrong ?

 

Thanks!

 

 

4 comments
Comment actions Permalink

Hi,

Could you specify DataGrip version you use?

If you leave database field empty you can specify databases you want to work by pressing `Schemas...`:



Thank you.

0
Comment actions Permalink

Thanks for answering.

 

I am using version 2017.1.5, Build # DB-171.4694.58  (6/26/2017)

 

I have left the database name empty and it connects me to master.  I can also open the schemas dialog and specify which individual schemas I want to work with.  I can even select "All Databases" at the top of the dialog.  But all this does is show me the database names.  




It seems like the "All Databases" option doesn't do much.  I can still connect to master and see objects in that database, not for any others. 

The only way to see everything is to open the schemas dialog, expand each database and select "all schemas" for every single database.  For thousands of databases, this is a pain.  

 

0
Comment actions Permalink

Hi,

As a temporary workaround, you need to specify schemas you want to work with.

Thank you.

0
Comment actions Permalink

Thank you Vasily,

 

I will do that.  I apologize for comparing to SSMS.  I realize that was a bit unfair.   

0

Please sign in to leave a comment.