On Sep 6, 2004, at 11:42 PM, Kevin J. Menard, Jr. wrote:
> Hi,
>
> I have a project, and would like to modify the DB schema a bit (adding
> new columns) without deleting all of my existing data. I know the
> data modeler will create SQL commands to create tables, but is there
> any functionality for it to create update commands? If not, what's
> the best way to go about this? Update the SQL manually and the
> rebuild my model in the data modeler by reverse-engineering the DB
> schema? Or something different?
Hi Kevin,
If this is just such simple change, I would manually add a column to
DB, and then manually add a corresponding attribute to DbEntity in
CayenneModeler (and then you can "Sync ObjEntity with DbEntity).
Reverse-engineering may be an overkill, as you may loose some of the
model customizations (if you made any), such as flattened relationships
or non-default names.
Andrus
This archive was generated by hypermail 2.0.0 : Tue Sep 07 2004 - 01:00:17 EDT