Compare and Synchronize Data in SQL Server Databases

dbForge Data Compare for SQL Server is a powerful SQL comparison tool capable of working with big data and using native SQL Server backups as metadata source. With dbForge Data Compare you can tune your SQL database comparison, quickly analyze data differences in a well-designed user interface and effortlessly synchronize data via a convenient wizard.

Data comparison setup

Include tables or views into comparison by mask or individually

Exclude objects from comparison by mask or individually

Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables)

Float types rounding option

Ignore Case and Ignore Trailing Spaces options for string comparison

LOB comparison options

WHERE filter for limiting data that needs to be compared (e.g. in extra large tables)

How can I compare data in two databases with different structures?

User mapping feature allows comparing tables with different names and column set

Map one table in source with two or more tables in target (useful when table was split)

Custom Query feature allows comparing a table with a query result