Compare Two Tables Using T-SQL or Command Line Utility (tablediff.exe)
There is out too many ways to compare two tables in SQL server but I prefer to do this task
–DB Blog
There is out too many ways to compare two tables in SQL server but I prefer to do this task