so far we use erwin to model our databases.
We design the database in the logical model.
When generating ddl, we select the target database and then have the option through a so called post-script (erwin internal language can access whole model and properties) to add additional ddl statements to the output, depending on logical model properties and other system variables.
Now switching to TOAD (we are testing v3.6) we have some questions:
- where can i find the reference of the object model used by the scripting machine ?
It seems to us, that there is actually no doc available for this ( we also found no doc what system objects are predefined like DDLScript.WriteLine, … and in which context they can be used)
- are there examples on how we can extend the ddl generation process per dbms ?
- is it possible to create user defined properties in the logical model, which can be set by user and which are available when converting to a physical model (or can be transformed in any way) ?
- are there examples on how we can make dbms specific modifications to the physical model (f.i. create triggers,…) when we convert from the logical model ?