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
Please sign in to leave a comment.
Hello Fabio,
Seems you've already posted issue on YouTrack: https://youtrack.jetbrains.com/issue/DBE-7255
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.
Fabio,
No, it's still there, but project was switched from "IDEA" to "DataGrip".
Hey,
I have the similar requirement
Is the solution around ?
S Gholap
Database script run configurations:
https://www.jetbrains.com/help/datagrip/creating-and-editing-run-debug-configurations.html
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
S Gholap
This is how I do it:
Notice how you can add both data sources and individual schemas as a target.
I guess I followed above steps.
I did not see the query result in above video
Displaying bulk query results in the console is currently not supported.
where I can see the query result ?
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.
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
S Gholap I agree.
Feel free to vote for DBE-10653 and leave additional comments there.
Looking forward for this feature