why datagrip supports single database in one connection?

my service use multiple databases in mysql. i need auto complete about another database's table reference and 'dbforge' supports that. And dbforge shows every databases on 'Database Explorer' tab. why datagrip supports single database in one connection?

7
11 comments

I agree. This is probably the main reason why I'm not going to buy DataGrip yet and why I can't suggest it to my team. I've got 75 databases which I manage on a single server and needing to setup a connection to each one would be a nighmare.

2

Hello,
Please enable Resolve unqualified references check-box in Schemas tab for needed databases and schemas to have auto-completion work without needing to prefix table with the schema/database. This will help.

0

Do you also use MySQL? Does mentioned suggestion help?

0

It does not help me.  I have a postgres application with multiple databases.  When I edit a sql file, I don't have an option to specify which database I want to use to run it.

1

Agreed. Datagrip looks like something my organization would LOVE but because we have hundreds of databases, we can't even try it.

0

Still waiting for this feature.

0
Avatar
Peter Swartwout

I use postgres with multiple databases. DataGrip makes me open a separate connection for each database, even though they are really the same connection. This is not how Postgres is organized. I want this nested structure:

Connection 1

  • Db1
  • Db2

Connection 2

  • Db1
  • Db2

Currently I must do this:

Connection 1 with unique name

  • Db1

Connection 1 with different name

  • Db2

Connection 2 with unique name

  • Db1

Connection 2 with different name

  • Db2

 

0

Hi,

Multiple database support will be available in DataGrip 2017.2 and also in DataGrip 2017.2 EAP.

Thank you

0

@Menashehyperomsik Hi,

Did you install DataGrip 2017.2?

Here is a screenshot with an example:

Thank you.

0

Thanks Vasily ,

I can use multiple databases now with DataGrip

1

Please sign in to leave a comment.