Triggers
Below is a small example of the trigger translation. MySQL allows direct referencing of old and new record's values, while SQL Server exposes them as virtual tables, so we need to query them.
MySQL source definition
SQL Server target definition
May 17, 2012