Hello Monks,
I have an issue with copying tables. I have a very complicated back end system, and I am copying the information out of that database (4 times aday) into a db that is more usable and I don't have as much of an issue giving others access to. (The primary db will only allow 10 connections as that is all we have licenses for)
Option 1: Using transactions, delete everything in the dest table, copy the new values in, commit the transaction. I don't really like this as it seems that it is over kill on work on the db, but it is the quickest way to code it.
Option 2: Write too loops, one loop goes in to the src db and selects the primary key row and checks to see if the same primary key is in the other database, if it is, stop, if not insert the rec into the dest db. Then do it in reverse but delete from dest db if it is not in the src db.
I know there has to be a better way then what was described. I am hopping that someone can help me. I do know about DBI::COPY to copy one table to anyother, but I have too much translation that has to go on to use it.
Thanks for your help

In reply to Db table to non-alike db table copying by Anonymous Monk

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.