You can compare the data that is contained in two databases. The databases that you compare are known as the source and the target.
Note Database projects and .dacpac or .bacpac packages cannot be the source or target in a data comparison. As the data is compared, a Data Manipulation Language (DML) script is generated, which you can use to synchronize the differing databases by updating some or all of the data on the target database. When the data comparison finishes, its results appear in the Data Compare window of Visual Studio. After the comparison finishes, you can take other steps: For more information, see Compare and Synchronize Data in One or More Tables with Data in a Reference Database. Comparing Database DataTo compare data by using the New Data Comparison Wizard
To compare data by using the Visual Studio automation model
Viewing Data DifferencesAfter you compare the data in two databases, Data Compare lists each database object that you compared and its status. You can also view results for the records within each object, grouped by status. For more information about the status designations, see Compare and Synchronize Data in One or More Tables with Data in a Reference Database. After you view the differences, you can update the target to match the source for some or all of the objects or records that are different, missing, or new. For more information, see Synchronizing Database Data. To view data differences
Synchronizing Database DataAfter you compare the data in two databases, you can synchronize them by updating all or part of the target to match the source. You can compare the data in two kinds of database objects: tables and views.
See AlsoCompare and Synchronize Data in One or More Tables with Data in a Reference Database |