Q:

How can I compare 2 sql server databases schema and get the update script

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.

A:

This one is really popular, but it's not free.
Apex SQL
If your using SQL Server 2005 or 2008. You can try these
SQL Server Database Comparison Tool
DB Comparer
You can also use the Schema Compare option in SSMS.

