What is best tool to compare two SQL Server databases (schema and data)?

Microsoft Visual Studio Community Edition (Free) has a tool called Data Compare and Schema Compare.

Visual Studio -> Tools -> SQL Server

Red-Gate

• http://www.red-gate.com/products/sql-development/sql-compare/
• http://www.red-gate.com/products/sql-development/sql-data-compare/