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

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


sql sql-server database compare

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!

img

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

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

img
(source: spaanjaars.com)

sql sql-server database compare

I like Open DBDiff.

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

sql sql-server database compare

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

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last