Which tool is best for comparing two SQL Server databases?

I use the entire redgate suite myself for my work; sql compare and/or sql data compare depending on if you want to compare the structure of databases, or the data in databases.

What are you trying to achieve? Deciding on what database server to use for your product?