We all know that the function of VS is so much more than you used to, and today this new schema Comparison, what he can do is to compare the architecture and structure of our two databases in VS, and be able to update the past or generate scripts.
STEP.1 (tool--sql server--new Schema Comparison)
STEP.2 Selecting the source database and the target database
STEP.3 Click Compare Compare
This is the result of the comparison (left to right of the difference, there are additions, modifications and so on. Tick the different to update to the right)
STEP.4 you can update it by clicking Update. You can also generate scripts
This is the simple operation. It is very convenient to compare two databases. Usually have the development of database and sit database. This will make it easy for us to develop new databases to join. Things like stored procedures are updated to the SIT database.
That ' s All,thank you
Database schema Comparison tool in vs2015 (New schema Comparison)