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


--

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]

Reply via email to