Hi, I just had a run-in with our database guy who needed two hours and numerous retries to provide a sql script to move our database to my latest model changes (really simple ones), and it's not all correct even now because he forgot to remove some columns and tables.
Anyway, this lead me to the conclusion, humans are ill suited to write database migration scripts. It would be quite handy if I could somehow take two models, compute the difference and issue the sql to change my create/drop/alter my tables. Now the create/drop stuff is quite easy, but with altering tables I don't know. Is there anything in sqlalchemy that helps at this task? Any startpoints? Cheers, Florian ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users