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

sql sql-server database compare
Tomasz Smykowski picture Tomasz Smykowski · Mar 26, 2009 · Viewed 413.3k times · Source

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?

Answer

Konstantin Tarkus picture Konstantin Tarkus · Mar 26, 2009

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)

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but …

Read More