Execute the same query on multiple databases

Answered

Hi,

I have 80 clients who are using my PHP application, so it means 80 different databases with the exact same structure.

I already have created the datasources on IntelliJ.

When I want to add new fields or indexes or create a new table, is there a way to do it on all databases at once from the IntelliJ DB console?

 

Thanks,

Fabio

14 comments
Comment actions Permalink

I see, I can do insert/update/delete operation which will reflect into db.

But support of select statement which will show aggregated info  will help a lot

1
Comment actions Permalink

Hello Fabio,

Seems you've already posted issue on YouTrack: https://youtrack.jetbrains.com/issue/DBE-7255

0
Comment actions Permalink

It was a mistake. I mixed up bug reports and forums.

And as I couldn't find my issue on Youtrack (searching by:me), I thought the issue had been deleted.

0
Comment actions Permalink

Fabio,

No, it's still there, but project was switched from "IDEA" to "DataGrip".

0
Comment actions Permalink

Hey,
I have the similar requirement 
Is the solution around ?

0
Comment actions Permalink

I went though the link.
Not clear yet.

Do I have to create multiple connection first ?
- Multiple connection to db
- How to provide multiple schema for same query

I have tried add multiple schema it gives no result 

0
Comment actions Permalink

S Gholap

This is how I do it:

Notice how you can add both data sources and individual schemas as a target.

0
Comment actions Permalink

I guess I followed above steps.
I did not see the query result in above video 

0
Comment actions Permalink

Displaying bulk query results in the console is currently not supported.

0
Comment actions Permalink

where I can see the query result ?

0
Comment actions Permalink

The purpose of introducing DB Script run configurations was to make bulk updates possible in the first place. The only available output is what you can see in the console.

0
Comment actions Permalink

S Gholap I agree.

Feel free to vote for DBE-10653 and leave additional comments there.

0
Comment actions Permalink

Looking forward for this feature 

0

Please sign in to leave a comment.