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

I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?

I use schema and data comparison functionality built into the latest version Microsoft Visual Studio 2015 Community Edition (Free) or Professional / Premium / Ultimate edition. Works like a charm!

http://channel9.msdn.com/Events/Visual-Studio/Launch-2013/VS108

Red-Gate's SQL data comparison tool is my second alternative:

_{(source: spaanjaars.com)}

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

I like Open DBDiff.

While not the most complete tool, it works great, it's free, and it's very easy to use.

I am using Red-Gate's software: http://www.red-gate.com