Author Topic: How to customize the "Generate Package DDL" script (Read 2994 times)

jboblitz · « **on:** May 23, 2011, 04:58:20 pm »

I would like to modify the script used to generate the ddl from my data model to set some DB Vendor Specific attributes, but I am unable to find the place to do so. The Code Generation Templates do not include the ddl scripts, so they must be somewhere else ....

anyone know where?

Aaron B · « **Reply #1 on:** May 23, 2011, 05:14:26 pm »

It's not possible to modify the templates for DDL generation at this time. Can you specify the type of DB attributes you are trying to model and generate?

jboblitz · « **Reply #2 on:** May 23, 2011, 05:30:42 pm »

Thanks for the fast response!

I am trying to implement table inheritence in Postgres and would like to have the create table reflect this ... OR baring that - that the generation of the ddl would include the columns from the "super" table.

Aaron B · « **Reply #3 on:** May 24, 2011, 08:59:44 am »

Inheritance might be best handled at this time by first building your model as a PIM, then transforming to a data model. For more information on the built-in DDL transformation and how it handles generalizations, see:
http://www.sparxsystems.com/enterprise_architect_user_guide/8.0/software_development/ddltransformation.html

jboblitz · « **Reply #4 on:** May 24, 2011, 03:36:08 pm »

Unfortunately, that will be more work than just coding it ... any plans for allowing a modification of the ddl scripts analogue to the source code script modification possibilities?

Sparx Systems Forum

News: