I have a request and I'm unable to use 3rd party tools such as RedGate. I'll be creating a database that will have staging tables and history tables. Prior to the data going to the history tables I need to compare the data between both tables and send out notifications if any of the data has been changed, deleted, or added.
What is the best way to do this without the use of 3rd party tools? As of now I'm not sure of a record count for each table, but its 10 tables and the compare process will be from 2 - 5 columns per table.