Monday 28 December 2015

SQL table compare between 2 databases

SQL Server Data Tools for Visual Studio 2013 -Run as Administrator
TOOLS-->SQL Server-->New Data Comparison...
Click on New Connection..under Source Database
Select SQL Server Name and DB Name
Click on New Connection..under Target Database
Select SQL Server Name and DB Name
Click Next
Select Tables which you want to compare
Finish
You will see data difference b/w 2 DBs