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

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Wed Aug 31 2005 - 14:03:24 EDT

  • Next message: Gentry, Michael \(Contractor\): "RE: "Best Practices" for handling changes to database schema?"

    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:03:28 EDT