why? what database(s)? no, you can't do that (how would it work??).. but you can just open two connections and work with each of them:
my $dbhA = DBI->connect($data_sourceA, $usernameA, $authA, \%attrA)
+or die ...;
my $dbhB = DBI->connect($data_sourceB, $usernameB, $authB, \%attrB)
+or die ...;
If you're trying to do cross-db joins or something, you'll have to do it in perl (or move all the data into one or the other, or a 3rd temp database).
If you're just copying code from one to the other, try DBIx::Copy as well as Super Search for lots of related threads.
| [reply] [Watch: Dir/Any] [d/l] |
Take a look at DBD::Multiplex | [reply] [Watch: Dir/Any] |
DBD::Multiplex is definitely what you're looking for.
My criteria for good software:
- Does it work?
- Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
| [reply] [Watch: Dir/Any] |
Quite simply, no. I think you had better explain why you might want to do this, as I for one can't actually think of any sensible use for such a facility. If you want to mirror data updates across more than one database then you probably want to be doing this at the database server level rather than your application code.
/J\
| [reply] [Watch: Dir/Any] |