|Subject||Re: [firebird-support] Re: How to rebuild all stored procedures / triggers|
I want to implement this feature to my update process, because it is impossible to do this in every update for all client instalations.
OK, I can do the following, to parse all SQL from metadata and alter them, but the question still remains unanswered:
Should I call "alter procedure" and "alter trigger" on all SP or TR.
If yes, then what about order to execute them? Does the order matter?
<<< 05.11.2014 17:10 - todd@... [firebird-support] "email@example.com" >>>
I use IB Expert. It will build a script that alters all your stored procedures to empty. Just the input and output parameters are in place. Then it alters them again populated. This means you don't need to be concerned in what order you create them. It also will build a script that will alter all your triggers.
We do this periodically in our clients installations because we want all of them to have the exact same metadata.
Best regards, TRoland