Re: "Best Practices" for handling changes to database schema?

From: Jeff de Vries (jdevrie..frog.com)
Date: Wed Aug 31 2005 - 14:14:33 EDT

  • Next message: Gentry, Michael \(Contractor\): "RE: Trying to set qualifier on a saved query?"

    That worked great. Thanks for such a quick response!

    Gentry, Michael (Contractor) wrote:
    >The easiest (and I'd argue best) at this point is to add then column to
    >your database table, then in Cayenne Modeler, manually add the column to
    >your DbEntity and then synchronize your ObjEntity with the DbEntity (it
    >sounds harder than it is).
    >
    >/dev/mrg
    >
    >
    >-----Original Message-----
    >From: Jeff de Vries [mailto:jdevrie..frog.com]
    >Sent: Wednesday, August 31, 2005 2:01 PM
    >To: cayenne-use..bjectstyle.org
    >Subject: "Best Practices" for handling changes to database schema?
    >
    >
    >I used Modeler to reverse engineer an existing database. I make several
    >
    >changes (flattening relationships, changing some names, etc), and saved
    >out my cayenne.xml file. I now need to add another column to one table
    >back on the database. Do I need to re-reverse engineer the whole
    >database and make all my changes all over again, or is there a "better
    >way"?
    >
    >Thanks,
    >Jeff de Vries
    >
    >

    This archive was generated by hypermail 2.0.0 : Wed Aug 31 2005 - 14:14:37 EDT