Re: Database migration
- From: rnorwood@xxxxxxxxxx (Robin Norwood)
- Date: Tue, 17 Oct 2006 23:17:56 -0400
Robert Hicks <sigzero@xxxxxxxxx> writes:
Omega -1911 wrote:
On 10/17/06, Robert Hicks <sigzero@xxxxxxxxx> 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
.
- References:
- Database migration
- From: Robert Hicks
- Re: Database migration
- From: Robert Hicks
- Database migration
- Prev by Date: Help with HTML::TableExtract
- Next by Date: Just asking ... (dot) . and (no dot)
- Previous by thread: Re: Database migration
- Next by thread: Re: Database migration
- Index(es):
Relevant Pages
|
