EMS DB Comparer for SQL Server is an excellent tool for SQL Server database comparison and synchronization. It lets you work with several projects at once, define SQL Server comparison parameters, print difference reports, and alter modification scripts.