Keep It Simple, Stupid | |
PerlMonks |
Re: Searching for Module to Mirror Database Tableby simonm (Vicar) |
on Jan 23, 2006 at 17:28 UTC ( [id://524981]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|