Hey Florian,
Wow, it seems this topic comes up every *checks mailing list-has it really
been that short?* few weeks. For reference, see the thread:
http://www.mail-archive.com/sqlalchemy-users@lists.sourceforge.net/msg00783.html
And also the prospective SoC project here:
http://www.mail-archive.com/sqlalchemy-users@lists.sourceforge.net/msg01644.html
I think the short answer is, please, yes, write something, but good luck with
the devilish details :P
-G
On Tuesday, May 9, 2006, 2:49:52 PM, you wrote:
> 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
-------------------------------------------------------
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
