Another great tool for comparing and synchronising SQL Server
databases (schema and data) is DB Ghost from Innovartis. It can also
let you manage your "source" database as a set of CREATE scripts under
source control:
http://www.dbghost.com
http://www.innovartis.co.uk