It sounds like a matter of having two connections, one for each database, BUT - If you trying transfer data from one database to another without doing any sort of data massaging, you may be creating alot of extra work for yourself by trying to script the transfers.

I hate to discourage you from using perl for this, but it's probably not the most easy or efficient way of doing so.

If you are trying to transfer between two databases with the same engine (that is MySQL->MySQL or Access->Access, check your engines docs. Most of them have nice utilites that will allow you to do transfers w/o scripting.

If you are trying to transfer between heterogenous dbs, then still check your docs. Many dbs have utilities that allow for imports.

If you DO have to do some massaging, though, Perl/DBI might be a pretty good pick.

Hanlon's Razor - "Never attribute to malice that which can be adequately explained by stupidity"

In reply to Re: DBI connection to multiple databases by Art_XIV
in thread DBI connection to multiple databases by Win

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.