SQL Data Compare is a industry-standard tool for comparing and deploying SQL Server database contents.
Presently Microsoft Visual studio Data Tool provide Schema and Data Compare inbuilt feature.
In Visual Studio 2017, Go to Tools > SQL Server > New Schema Compare > Select Source Db> Select destination DB
Using this compare tool you can compare Data and Schema of source and destination database, also you can compare different versions of same database.
The result of the comparison between two databases or database projects is analysed and allows you to apply the change from source database to target, or simply generate T-SQL scripts you can view, modify and run at your control.