Two databases when you merge, it's nice to have a visual tool. Someone had thought of this earlier and had an open dbdiff. Link Address: https://opendbiff.codeplex.com/
This tool can be compared to tabular patterns and tabular data.
But there are a few shortcomings:
(1) If there is too much data on the table, errors may occur when loading. and cannot load data on a specific condition
(2) When data is matched, the merge rule is whether the comparison index is the same, and the merge rule cannot be customized.
(3) compared to the data, if you can like the code compared to the tool, the same data alignment is better.
(4) Only one-way merge is supported, not bidirectional.
However, the contribution of the author is still appreciated.
Reprint Please specify: Kangrui tribe? SQL Server Database comparison tool Open Dbdiff
SQL Server Database comparison tool Open Dbdiff