How to trigger an action without using triggers I just want to ask. We have a calendar table, let's call it CAL1 in one database, lets call it DB1. CAL1 is manually populated. Now in another database, DB2, there is another calendar table CAL2. What I need to do is to populate CAL2 based on the values from CAL1. I don't know when will CAL1 be populated. There is also some other calendar tables/tables in other databases that will refer to CAL1 so I need to make an API that will populate or at least execute the procedures from the other databases e.g. DB2 whenever new data is loaded to CAL1. I initially think of using triggers but read that it's better to not use it. So is there any other way that I can do this without using trigger? Thanks a lot.
it depends on how up to date you want CAL2 to be.

If it immediately should reflect the values in CAL1 then a trigger is the way to go.

If it can be a few mnutes out of sync then you could have a job that runs every 5 mins and calls a stored procedure that syncs the tables.