in reply to Obtaining SQL updates for application to another database

Why not just warning or printing to somewhere the statements that are updates?
It's in your script, just echo it.
then the DBA can just copy and paste then or execute as an sql script.
maybe i didn't get the correct picture of what you intend to do... thx
  • Comment on Re: Obtaining SQL updates for application to another database

Replies are listed 'Best First'.
Re^2: Obtaining SQL updates for application to another database
by rinceWind (Monsignor) on Apr 05, 2005 at 11:52 UTC

    The script uses Class::DBI. Updates to individual columns consist of method calls. The whole idea behind Class::DBI is that it is an object persistence layer, and enables the developer to avoid writing SQL.

    If the script were using plain vanilla DBI, it would contain SQL, but probably be at least twice as long.

    --
    I'm Not Just Another Perl Hacker