I would not like to use TRIGGERS for this, but I think it's the only way.
I have 2 databases with the same structure. What I would like to do is when someone inserts/updates something in this table from Database1, it should insert/update in the same table on database2. should I use triggers on this? I don't like to use triggers because it can mess things up.