Now, I would like to move these seed data scripts out of the model and
into Subversion (SVN), so that others can update the seed data. I drop
a file object on the PDM diagram, then edit its properties by
unchecking GENERATE, checking ARTIFACT, and setting it's external
location to my local SVN repository location of the desired seed data
script file (*.sql).
I would like to create some script that automatically identifies those
extended dependencies (from table to file) and then automatically
replaces the SCRIPT AFTER tab contents with the contents in the target
file. I can use a specific stereotype SEEDDATA to identify the
dependencies.
I know PowerDesigner has the capabilities to automate this, but I need
some help to push me onto the right track. I have not yet done any
scripting inside PowerDesigner to begin this task. Any help is
appreciated, thanks.
Regards,
Mark
There's a download link at the bottom where you can download a sample
file. Let me know if you run into any problems, this was my first
attempt at including a download link. Please share any improvements
you come up with.