sql to update existing database?

[Ondřej Čada]

Hello there,

is there a script or Entity Modeller tool or whatever to generate a "diff" SQL for given model and existing database, so that tables get created for new entities, but updated (by adding columns) for the already existing ones?

Seems to me basic enough functionality for someone already have done that, but can't find anything on the web...

Thanks and all the best,
---
Ondra Čada
OCSoftware: ***@ocs.cz http://www.ocs.cz
private ***@ocs.cz http://www.ocs.cz/oc

[Chuck Hill]

I don't recall anything like that. It does sound like it would be useful if the project was not started with Wonder Migrations.


Chuck

Post by Ondřej Čada
Hello there,
is there a script or Entity Modeller tool or whatever to generate a "diff" SQL for given model and existing database, so that tables get created for new entities, but updated (by adding columns) for the already existing ones?
Seems to me basic enough functionality for someone already have done that, but can't find anything on the web...
Thanks and all the best,
---
Ondra Čada
_______________________________________________
WebObjects-dev mailing list
http://www.omnigroup.com/mailman/listinfo/webobjects-dev

[Ondřej Čada]

Chuck,

Post by Chuck Hill
I don't recall anything like that. It does sound like it would be useful if the project was not started with Wonder Migrations.

Thanks.

I've tried to rig something, but alas to do it right is not exactly a hour's work, so at the moment I'm afraid I'll stick with doing the diffs manually :)

All the best,
---
Ondra Čada
OCSoftware: ***@ocs.cz http://www.ocs.cz
private ***@ocs.cz http://www.ocs.cz/oc