Open DBDiff is a database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script.
Database compare tool
Data modeling tool
Database design tool