Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re: Searching for Module to Mirror Database Table

by simonm (Vicar)
on Jan 23, 2006 at 17:28 UTC ( #524981=note: print w/replies, xml ) Need Help??

in reply to Searching for Module to Mirror Database Table

Consider using a text-file dump to extract data from the old database in a consistent format and order, and then copy that to location B and use the standard "diff" tool to compare it with the previous file copied over on an earlier iteration.

By reading the diff output, you should be able to spot which lines have been deleted, which modified, and which ones added... From there, it should be relatively easy to generated the INSERT/DELETE/UPDATE queries.

  • Comment on Re: Searching for Module to Mirror Database Table

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://524981]
[mark4]: Did activestate use to inclued teh perl packager, pp.exe in the standard distribution? I can't fine "pp.exe" anywhare.
[marto]: no

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (14)
As of 2018-01-19 14:04 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (218 votes). Check out past polls.