Data Compare for SQL Server- version 11

Data Compare for SQL Server allows you to compare and synchronize data in SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data etc.

Data Compare supports SQL Server 2000 to 2019, Azure SQL Database and it is available for FREE as a fully functional Lite Edition (see the "Editions" below).

For a list of the new and improved features included in the version 11 of the data comparison, click here.


  • Compare data in two SQL Server databases, both tables and views
  • Custom mapping of database tables, views, schemas and data types
  • A simple and efficient user interface
  • A workspace that stores settings, comparison sessions, with support for one-click compare
  • Map data rows using built-in keys and unique indexes, or create your own custom keys
  • Compare whole tables or portion of them, selected via the custom where clauses
  • Variable batch and transaction size
  • Command line tool, including a wizard for creating and managing command line config files
  • Compare on-premise SQL Server 2000-2019 and Azure SQL Database


xSQL Data Compare for SQL Server runs on Windows operating systems that have the .NET framework 4.6 or higher installed.

Version Information

    Major Version
  • Version Number: 11.0
  • Release Date: December 02, 2019
    Current Version
  • Version Number:
  • Release Date: April 23, 2020


Comparison Engine - robust, highly efficient comparison engine compares millions of rows fast while tightly controlling resource utilization. There is no technical limit in the size of databases that SQL Server Data Compare can synchronize.

Modern GUI - SQL Server Data Compare's GUI reflects the latest standards in user interface design. Context sensitive ribbon, action panels with clear descriptions, asynchronous implementation of lengthy operations, detailed progress information and more.

One-click re-compare - SQL Server Data Compare maintains a comparison session history. A session is a persisted environment that contains all the data related to a comparison operation including databases and the respective credentials, comparison options, mapping rules, excluded objects and many more. It allows the end-user to repeat a comparison with a single click. Options control the way sessions are sorted and the max number of sessions that are persisted.

Custom mapping - the mapping rules feature allows you to customize the way SQL Server database objects are paired together. Mapping rules include: "Schema mapping rules" that determine how the database schemas are mapped; "Name mapping rules" that determine how the database object names are mapped; and "Data mapping rules" that determine how sql data types are mapped.

Custom comparison keys - you want to compare database tables or views but they are showing as non-comparable because there is no primary key or unique indexes defined on them? Once xSQL Data Compare for SQL Server has analyzed the database schema it will allow you to define a unique key (any combination of the columns of that table) to use for the sql data compare. The rows will be paired based on the selected key.

Command Line utility - the included, highly configurable command line utility allows you to schedule data comparison operations via the Windows Task Scheduler, SQL Server Scheduler etc. A step-by-step wizard helps you to create and manage the config files used by the command line, generating consistent, always up-to-date xml files.

Full control over the comparison and synchronization - a wide array of options gives you granular control over the behavior of the sql database comparison engine. Comparing database views along with sql database tables, analyzing table dependencies and arranging the t-sql synchronization script accordingly, comparing sql databases with different collations are just some of the available options.

Handling large databases - custom built algorithms handle serialization of both data rows and t-sql script fragments as needed ensuring strict control of the memory utilization.

Script execution engine - the proprietary, intelligent script execution engine ensures that very large t-sql scripts including scripts for binary columns and large text columns are executed successfully while providing continuous progress information and allowing you to safely interrupt the script if necessary.

Error handling - systematic error handling aims at eliminate unexpected / unexplained results. Non-critical errors are registered and reported but do not interrupt the operation. Errors are reported via dialog boxes or printed on the output panel. A full error log is created.

Starting from:  $399
Best Value
Consider Silver Subscription - SQL Server Tools instead. It contains:
Additional Information
  • ...The speed, ease of use and most importantly, the support when there's an issue, make this suite my product of choice...
    Brenton G.
    ASPGUY-Independent Consulting, TX
  • ...It also features the best (and simplest) way to move objects and data via sql script I’ve ever seen. I’m hooked.
    Steve F.
    Creative Plumbing, GA
  • We have tested ... and compared it with 6 other products. We preferred xSQL Data Compare...
    Han van der H.
    RIVM LTR Laboratory, The Netherlands