https://www.red-gate.com/products/sql-data-compare/
SQL Data Compare: Compare And Synchronize SQL Server Database Contents
Use Redgate SQL Data Compare to compare and synchronize static, lookup, and reference data in your SQL Server database - try it free
sql data comparesynchronizeserverdatabasecontents