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