How to move data to a table whenever an update on another table

[Former Member]

Hi Experts,

I have table A and table B. I want to move data from table A to table B whenever there is an update on table A. What is the way to do so in Hana?

I know trigger is not good way to do so in Hana. Could you please tell me the code or logic of procedure for the same

Thanks,

Deepa

[lbreddemann]

Can you explain your use case a bit more? “Moving data” is not a business requirement but how you think you want to enable the requirement.

Also, what makes you think that triggers in HANA are less “good” than in any other DBMS? Triggers are problematic in any DBMS.