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

Reply via email to