Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2400
  • Last Modified:

PowerDesigner 11: how to generate db creation script if there are views dependent on functions?

Hello Experts,

I design a db in PowerDesigner 11. There are number of server-side functions, and there are views that use the funcs. Meantime, some of funcs use views. There's no circular dependency, however.
Is there any way to generate script that will create the db with views and functions taking into account dependencies?

Thank you.
1 Solution
It's been a while since I used PD (great tool !!!) but as far as I can remember, PD can't for some reason generate one single script that takes thsi into account. I never managed to solve it ... I ended up with manually running the functions that were required in the views ...

Hope this helps ... although it was not what you were looking for ...
Ditto PD - great tool.

And I concur with above - I haven't found a way of doing this
MMS_PDAuthor Commented:
The only solution I found is upgrading to PD 12.5
PD 12.5 generates CREATE VIEWs and CREATE FUNCTIONs in one single script taking care of extended dependencies.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now