DDL change scripts

[Eamonn John Casey]

Hi,
I reverse engineered a database into a UML Class diagram. Is there any good description about how I can generate DDL change scripts when I just add or remove columns? I tried using Database Builder but the description in the documentation is not very clear. I can't get it to recognise column changes.
Anyone have or know of a better description.

Thanks,
Eamonn J.

[qwerty]

There is no such description since EA lacks this functionality. You can only create a whole DDL. It's probably possible to script a diff function (but I doubt it's worth the effort).

q.

[Sunshine]

As mentioned Sparx only generates DDL for the whole database not changes. However what you could do is use that to create a new database then use one of many tools out there to compare the two databases and create change scripts to apply to the first database.

I know other tools like Sparx provide that capability so you might like to put a feature request in to Sparx Systems and if your lucky they might implement it some time in the future. Doesn't help you immediately I know but would help others in the future.   

[Dermot]

The Database Builder does support synchronizing the DBMS structure with change scripts. I suggest you have a look at the example in the whitepaper and webinar covering the Database Builder:

http://community.sparxsystems.com/white-papers/933-introduction-to-the-database-builder

http://www.sparxsystems.com/resources/webinar/database-engineering/database-builder-intro/database-engineering-in-enterprise-architect.html

[Sunshine]

The Database Builder does support synchronizing the DBMS structure with change scripts. I suggest you have a look at the example in the whitepaper and webinar covering the Database Builder:
http://community.sparxsystems.com/white-papers/933-introduction-to-the-database-builder
http://www.sparxsystems.com/resources/webinar/database-engineering/database-builder-intro/database-engineering-in-enterprise-architect.html

Thanks for bringing that to our attention. Didn't know it existed.