Visual Studio 2017 Pro - SQL Schema Compare

SqlSchemaCompare 

SQL Schema Compare from VS 2017 will compare all the objects from Source database to Target database.

Click on Tools > SQL Server > New Schema Comparism

Enter Source and Target Server and Database name

Click on Compare

After clicking compare button, you will see the objects which needs to be deleted, added , chanaged in Target Database.

You can update the Target my clicking Update button.

To generate the script, click on generate Script button

Sometimes, we need to compare indexes and tables between two databases. This is a useful tool for us.