This sample shows how to replicate data between two tables in different databases on the same server. I was looking for the most simple pragmatic approach I could think of. Please be aware that triggers have some disadvantages. Please think carefully before following the approach.
- If you insert a row in the table in database A
- a trigger will execute automatically