Yes, that would be nice. :-)
I think most of us probably do a first cut and then update the DB
manually (keeping the update scripts/etc in the repository) and then
update the model manually to reflect the changes. At least, that's the
pattern I've always seen.
/dev/mrg
-----Original Message-----
From: Todd O'Bryan [mailto:toddobrya..ac.com]
Sent: Friday, April 30, 2004 9:19 AM
To: cayenne-use..bjectstyle.org
Subject: Incremental Database Schema
One thing that would make Cayenne's modeler even more wonderful would
be the ability to, on the fly, change a Database Schema and have SQL
auto-generated that wouldn't require you to drop your tables (thus
losing all your data) and re-create them.
Something that would keep track of added or deleted attributes and
relationships and would just add or delete columns to handle them would
make it possible to change a system once its tables have already been
populated.
Am I the only person who evolves a system after it's already started
running?
Todd
This archive was generated by hypermail 2.0.0 : Fri Apr 30 2004 - 10:01:03 EDT