Robert Hicks <[EMAIL PROTECTED]> writes: > Omega -1911 wrote: >> On 10/17/06, Robert Hicks <[EMAIL PROTECTED]> wrote: >> >>> What is the best "Perl" way to migrate? >> Honestly, in Perl, the saying is "There is more than one way to do >> it" >> but without your showing what you have tried, then the "best" way to >> try is by writing code. I believe that is why no one has offered their >> help. > > Ok, I will do that tomorrow. I wanted to try it first. I have most of > what I think will work done. If I hit a snag I will post what I have.
One thing to keep in mind when doing things like this. Most people would think of doing this in one of two ways. Either: 1) Load all the data from the source db, then update the target db. or: 2) Load the data from the source db row-by-row, updating the target db as you go. For large sets of data, option '1' can use up available memory, and option '2' can be very slow due to the number of 'round trips' to and from the databases. So a 'batching' solution might be a good idea. Of course, if the data set isn't very large, either of the 'obvious' solutions will work fine. Good luck. -RN -- Robin Norwood Red Hat, Inc. "The Sage does nothing, yet nothing remains undone." -Lao Tzu, Te Tao Ching -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
