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.
SQL Server source definition
MySQL target definition
May 17, 2012