On Wed, Jul 16, 2008 at 8:29 PM, Chuck Hill <[EMAIL PROTECTED]> 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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
