There's a bunch of them out there and they mostly suck. https://docs.microsoft.com/en-us/sql/ssdt/how-to-compare-and-synchronize-the-data-of-two-databases?view

There's a bunch of them out there and they mostly suck. https://docs.microsoft.com/en-us/sql/ssdt/how-to-compare-and-synchronize-the-data-of-two-databases?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/ssdt/how-to-compare-and... https://www.red-gate.com/products/sql-development/sql-data-compare/ https://www.red-gate.com/products/sql-development/sql-data-c... https://www.apexsql.com/sql-tools-datadiff.aspx https://www.apexsql.com/sql-tools-datadiff.aspx