We don't bite newbies here... much | |
PerlMonks |
Obtaining SQL updates for application to another databaseby rinceWind (Monsignor) |
on Apr 05, 2005 at 09:26 UTC ( [id://444913]=perlquestion: print w/replies, xml ) | Need Help?? |
rinceWind has asked for the wisdom of the Perl Monks concerning the following question: Folks, I am looking for the best option here. I am supporting a legacy application that occasionally gets duff data in its database. I have written a reconciler perl script, using Class::DBI, which reports any inconsistencies. I have included an update option, which corrects the data; I have also put this in a transaction which can be rolled back at the end. My client's change management procedures require that the script is run by a DBA - supplying a write permitted username and password. During the testing phase, the DBA has asked me whether I can show him the SQL. I showed him DBI_TRACE, but even level 1 gives a copious amount of output, and it was a needle in a haystack finding the updates. Implementation of this particular data fix has been agreed according to the logic I have provided. What he is really looking for is a way that my script could emit the SQL updates, so that these can be taken into production and run in isolation - without needing to run my script in production. I am looking for a way of doing this - generically. I have several options:
I'm not sure which way to go on this one. Any suggestions? --
Back to
Seekers of Perl Wisdom
|
|