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 10:47:12 -0700
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!)
>
> --
>
> 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