title: How can I compare 2 sql server databases schema and get the update script
body: <p>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.</p>