I work in an operations group - part of the job function is that we have to run any ad-hoc SQL that needs to be represented as a change on a change control call.
Lately we've been getting requests to run the same SQL in anywhere from 2-60 different oracle databases. (for the case of an example - running an update statement to change some values in a user table).
For some reason I guess this problem hasn't come up before.
I'm trying to intelligently solve it so I'm not wasting time in the future logging into each one and running it manually.
Work I've done so far:
gathered all user names, passwords and what databases they are on one into a mysql database running on my machine (where I'm testing for the moment).
I have a column for each of those values and I have them all populated.
Conceptually - how do you think the best way to handle this would be?
I was thinking of just creating a PHP page with a bunch of checkboxes for the various databases and then a box to put the SQL into and it would chug along and maybe keep a little log of what it did along the way.
At the same time I'm kind of interested in learning python and maybe this would be a great first project.
Who knows, maybe there are tools out there that handle this problem already (MuSQL was one I saw but it doesnt seem to like that I didn't have a common username/password across all the databases).
Lately we've been getting requests to run the same SQL in anywhere from 2-60 different oracle databases. (for the case of an example - running an update statement to change some values in a user table).
For some reason I guess this problem hasn't come up before.
I'm trying to intelligently solve it so I'm not wasting time in the future logging into each one and running it manually.
Work I've done so far:
gathered all user names, passwords and what databases they are on one into a mysql database running on my machine (where I'm testing for the moment).
I have a column for each of those values and I have them all populated.
Conceptually - how do you think the best way to handle this would be?
I was thinking of just creating a PHP page with a bunch of checkboxes for the various databases and then a box to put the SQL into and it would chug along and maybe keep a little log of what it did along the way.
At the same time I'm kind of interested in learning python and maybe this would be a great first project.
Who knows, maybe there are tools out there that handle this problem already (MuSQL was one I saw but it doesnt seem to like that I didn't have a common username/password across all the databases).