Greetings punkish,

Part 6: the “on demand” part... the evolution of technology has unfolded into a plethora of technologies and programming languages to solve the problems we face. However, all too often these technologies must be bridged in order to achieve a higher purpose previously unattainable. That is were PERL comes in for me, an ambitious developing JAPH. I must caution your use of user initialization of the on demand part: I quote you "At times they make changes to the data on A. When they do that, steps in 4 should be run on demand, typically by pressing a button on the UI“ This may be a perfectly effective way of implementing this transference of data between technologies but, my experience is to never trust the end user. I would recommend automating the process as much as possible. You could read from an etime (edited time) of the record you could programmatically keep track of all the etimes in you master db you will know when to write to the slave db. Task Schedule your program to scan etimes every 10min, correlate and reallocate modified data. This would ensure that no data will ever be lost and the other db always has the data it needs. As far as the XML modules I am sure there are a plethora of them just make sure you scrub the web for additional repositories that don't come standard with the ActiveState Perl build. In these alternate repositories like Jenda's or Dave Roth's repositories you will find many win32 and possibly XML modules not available with the standard activestate's repository.

Hope this Helps!

Happy Hacking, 3dbc

In reply to Re: syncing disparate DBs via XML by 3dbc
in thread syncing disparate DBs via XML by punkish

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.