Re: Re[2]: Update DB Schema

From: Andrus Adamchik (
Date: Tue Sep 07 2004 - 10:17:27 EDT

  • Next message: Gentry, Michael: "RE: Re[2]: Update DB Schema"

    Hi Kevin,

    Well, actually Cayenne already supports synchronization with an
    existing schema (you can select an existing DataMap, and then do
    "reverse engineer", and Cayenne will update this DataMap, instead of
    creating a new one). Unfortunately the current implementation is a can
    of worms. We need a much cleaner "merge" support in the future.


    On Sep 7, 2004, at 8:13 AM, Kevin J. Menard, Jr. wrote:
    > Hello Andrus,
    > Tuesday, September 7, 2004, 1:00:09 AM, you wrote:
    > AA> If this is just such simple change, I would manually add a column
    > to
    > AA> DB, and then manually add a corresponding attribute to DbEntity in
    > AA> CayenneModeler (and then you can "Sync ObjEntity with DbEntity).
    > Ok. That's what I was figuring. But what should one do in a not so
    > trivial case? I know enough forethought should go in at the
    > beginning, but people make mistakes while others change their minds
    > (user requirements). Hopefully this all happens during the dev stage,
    > so you're not impacting a production system, but even on a dev system,
    > it would be a pain in the neck to lose all that data.
    > Steve's DBUnit ant solution looks nice, but it might be nice for data
    > modeler to have an import/export dump facility.
    > AA> Reverse-engineering may be an overkill, as you may loose some of
    > the
    > AA> model customizations (if you made any), such as flattened
    > relationships
    > AA> or non-default names.
    > Ahh, I hadn't considered this. I'll make sure not to do that then.
    > My intention with the reverse engineering was to make sure that what I
    > did in data modeler definitely matched against the db (i.e., that I
    > didn't miss a step).
    > --
    > Best regards,
    > Kevin

    This archive was generated by hypermail 2.0.0 : Tue Sep 07 2004 - 10:17:32 EDT