Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Eamonn John Casey on September 06, 2016, 08:53:33 pm

Title: DDL change scripts
Post by: Eamonn John Casey on September 06, 2016, 08:53:33 pm

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.

Title: Re: DDL change scripts
Post by: qwerty on September 06, 2016, 09:27:02 pm

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.

Title: Re: DDL change scripts
Post by: Sunshine on September 07, 2016, 07:31:41 am

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.   

Title: Re: DDL change scripts
Post by: Dermot on September 07, 2016, 12:27:00 pm

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

Title: Re: DDL change scripts
Post by: Sunshine on September 08, 2016, 07:42:26 pm

Quote from: Dermot on September 07, 2016, 12:27:00 pm

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.