Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

sql

database

sql-server

compare

People also ask

How do I compare schema of two databases in SQL Server?

To compare database definitions. On the Tools menu, select SQL Server, and then click New Schema Comparison. Alternatively, right-click the TradeDev project in Solution Explorer, and select Schema Compare. The Schema Compare window opens, and Visual Studio automatically assigns it a name such as SqlSchemaCompare1 .

How can I compare two SQL files in SQL Server?

Right-click on the right/left panel and click the Difference highlights option from the context menu. Go to the View tab in the main application window and click the Difference highlights button.

Which tool is used for data comparison?

Datanamic DataDiff is a powerful and easy-to-use utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely.

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)

  • 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


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'm partial to AdeptSQL. It's clean and intuitive and it DOESN'T have the one feature that scares the hell out of me on a lot of similar programs. One giant button that it you push it will automatically synchronize EVERYTHING without so much as a by-your-leave. If you want to sync the changes you have to do it yourself and I like that.

Related questions

SQL WHERE ID IN (id1, id2, ..., idn)
In SQL, how can you "group by" in ranges?
How can prepared statements protect from SQL injection attacks?
SQL Logic Operator Precedence: And and Or
Can someone copyright a SQL query? [closed]
How to select records from last 24 hours using SQL?
Change Schema Name Of Table In SQL
Best way to do nested case statement logic in SQL Server
How to create Temp table with SELECT * INTO tempTable FROM CTE Query
Set NOW() as Default Value for datetime datatype?
Most efficient T-SQL way to pad a varchar on the left to a certain length?
"where 1=1" statement [duplicate]
Count the number of occurrences of a string in a VARCHAR field?
Truncate (not round) decimal places in SQL Server
What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
sqlite database default time value 'now'
Why historically do people use 255 not 256 for database field magnitudes?
In SQL, what's the difference between count(column) and count(*)?
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS
How to export all data from table to an insertable sql format?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!