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

Posted on 2007-10-04
Last Modified: 2008-03-15
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.
Question by:MMS_PD
    LVL 18

    Expert Comment

    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 ...
    LVL 14

    Expert Comment

    Ditto PD - great tool.

    And I concur with above - I haven't found a way of doing this

    Accepted Solution

    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

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now