Sunday 2 July 2017

Visual Studio compare SQL server table Data Compare



Visual Studio => Tools => SQL Server => New Data Comparison ...
In the new window, Under "Source Database", Click on "Select Connection..."
Enter SQL DB Server name
Select Database
Click on Connect

In the new window, Under "Target Database", Click on "Select Connection..."
Enter SQL DB Server name
Select Database
Click on Connect

Check All check boxes

Click Next

Select Tables which you want to compare
Finish
You will see data difference b/w 2 DBs