SQL code compare - Compare SQL code, files and folders in SSMS for free. Compare two files and/or SQL objects and create a merge script. See next feature. SSMS and Visual Studio integration. Compare SQL Server objects directly from the Object Explorer and Server Explorer right-click context menus in SSMS and Visual Studio.
I'm not sure if there is such a tool... given 2 sql server databases, I want the tool to tell me what is different between the 2 and give me the update script. I.e. create indexes, create table, create relationship, etc... I don't need data comparing, just schema.
4 Answers
This one is really popular, but it's not free.
If your using SQL Server 2005 or 2008. You can try these
You can also use the Schema Compare option in SSMS.
Visual Studio Premium and Ultimate versions come with a Schema Comparison tool (TOOLS | SQL Server | New Schema Comparison...)
There is more information here
Sql Server Data Tools (SSDT) has a schema compare tool, with an option to generate an update script. The example image below is version 2015.
Try xSQL Schema Compare. It can compare any object in the database and generate synchronization scripts for all of the differences or just the ones you choose. Also, you can use it for free if you are using SQL Server Express.
Disclosure: I'm affiliated with xSQL.