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

0
14 comments

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

S Gholap I agree.

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

1

Hello Fabio,

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

0

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

Fabio,

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

0

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

0

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

S Gholap

This is how I do it:

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

0

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

0

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

0

where I can see the query result ?

0

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

Looking forward for this feature 

0

Please sign in to leave a comment.