Is it possible to define some DB-triggers that will only fire in some customers environment.
But we do not want to define that trigger at the customers site itself.
So we want to manage all DB-definitions (so tables/fields/triggers/...) in our development but only at a few customers we want to execute some trigger code for some events
Is this possible? and is this advised?
I guess I can make a trigger in our development that runs some program with no-error.
Then at the customers that we want some trigger-code for this event we create that program with the codings that are requested
This way we will have some customized trigger-code that can be different for every customer that wants to do something on some event.
But again: is this an advised approch?
Or is it better to just setup some CDC system? I have no experience with this.
But we do not want to define that trigger at the customers site itself.
So we want to manage all DB-definitions (so tables/fields/triggers/...) in our development but only at a few customers we want to execute some trigger code for some events
Is this possible? and is this advised?
I guess I can make a trigger in our development that runs some program with no-error.
Then at the customers that we want some trigger-code for this event we create that program with the codings that are requested
This way we will have some customized trigger-code that can be different for every customer that wants to do something on some event.
But again: is this an advised approch?
Or is it better to just setup some CDC system? I have no experience with this.