At the office I was recently exposed to a tool called SQL Delta. Tools like this have been around for quite awhile, but this has to be the slickest and easiest to use interface I have seen.

The description of the tool from the products web page is:

"SQL Delta is a database compare and synchronization tool that performs both structure and data comparisons of SQL Server 2005, 2000 and 7 databases."

We use it here to sync up data and structure between the various build/test/uat/dev instances of our database back ends. It generates scripts, can run inside transactions, all the things you would expect. A little expensive for the home user but very affordable for a team.

Cheers,

Robert Porter