Re: javaeoutil / bulkmover and friends.. Deep copy?
Re: javaeoutil / bulkmover and friends.. Deep copy?
- Subject: Re: javaeoutil / bulkmover and friends.. Deep copy?
- From: "Joe Little" <email@hidden>
- Date: Thu, 17 Jul 2008 12:55:20 -0700
On Thu, Jul 17, 2008 at 10:47 AM, Joe Little <email@hidden> wrote:
> On Wed, Jul 16, 2008 at 8:29 PM, Chuck Hill <email@hidden> wrote:
>>
>> On Jul 16, 2008, at 4:34 PM, Joe Little wrote:
>>
>>> I was wondering if the various bulk migration utilities between
>>> multiple databases correctly do deep copies, maintaining relationships
>>> with new primary keys, etc.
>>
>>
>> javaeotutil just does a data copy so you will get PK conflicts. I am not
>> sure what SRTransport does.
>>
>>
>>> I have a production DB that has been regularly renamed on a yearly
>>> basis to start fresh. I'd like to merge them into one now, retaining
>>> all deep relationships. One approach is to merge them all into the
>>> production DB and use present date fields to distinguish between them,
>>> but another idea, perhaps foolish, is to dumb them into a different
>>> entity type that inherits from a common ancestor, thus separating
>>> archived records from current records.
>>>
>>> Any insight on whether the tools of note are up to the task?
>>
>>
>> Inheritance might work better (easier) than a date field. In either case,
>> you are going to need to update the primary keys. The EO Copying stuff in
>> Practical WebObjects / the GVC Frameworks / (maybe in Wonder now too) is
>> probably what you want. But you will need two EOModelGroups and two EOF
>> stacks to do this. I am not sure if the EO Copying stuff will work in that
>> scenario, I think so but I have never used it like that.
>>
>> Chuck
>>
>
> I may have found the correct solution. http://www.opendbcopy.org
> handles many of these scenarios with referential integrity, etc. I'll
> need to check out how well it handles the multiple DBs passed through
> per single destination target, but the documentations (very good in
> comparison) implies that this is possible. Its a java/jdbc app, but
> uses Hibernate (oh, the sacrilege!)
>
It all was going beautifully until I ran into an execution error that
is hard to get around on the face of it. This project is current up to
2004. Its Postgresql plugins and such are dependent on Postgresql 7.x
and its driver causes an error, that on looking up, simply states that
I'll need an 8.x build of the product before it'll work with my DBs.
Doable, but it becomes its own project to upgrade this to more modern
times.
I guess that hard way with regards to EOModelGroups will be the next
thing. I'm most concerned about the deep copying, and sadly I think
some of my older DBs will have trouble with lack of correct
relationship handling anyways.
>>
>> --
>>
>> Practical WebObjects - for developers who want to increase their overall
>> knowledge of WebObjects or who are trying to solve specific problems.
>> http://www.global-village.net/products/practical_webobjects
>>
>>
>>
>>
>>
>>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden