Workshops and training for beginners to mastery level people on SQL Server can be found here: [ Ссылка ]
The last thing you want to do is truncate and load your data when your synchronizing two tables. In this video Bradley Schact and Brian Knight white board some of the common patterns and approaches to incremental loads in SQL Server.
