What is best tool to compare two SQL Server databases (schema and data)?
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 am using Red-Gate's software: http://www.red-gate.com
SQL Admin Studio from http://www.simego.com/Products/SQL-Admin-Studio is now free, lets you manage your SQL Database, SQL Compare and Synchronise, Data Compare and Synchronise and much more. Also supports SQL Azure and some MySQL Support too.
[UPDATE: Yes I am the Author of the above program, as it's now Free I just wanted to Share it with the community]
I like Open DBDiff.
While not the most complete tool, it works great, it's free, and it's very easy to use.