in reply to DBI connection to multiple databases

Just because most DBI examples don't show two simultaneous connections, doesn't mean it can't be done.

Just off the top of my head (not tested, debugged etc)

use DBI ; $dbh1 = DBI::connect(...) ; $dbh2 = DBI::connect(...) ; $sth1 = $dbh1->prepare(...) ; $sth1->execute(...) ; @row = $sth->fetchrow_array(...) ; $dbh2->do(..., @row) ;