A simple and intuitive interface, combined with a context-sensitive ribbon, provides easy access to all functions and operations.
A carefully-designed workspace stores data sources, credentials and other settings in one central place.
Comparison sessions, saved automatically in the workspace, allow you to rerun the most frequent comparisons with just one click.
Whether you compare a few rows or millions of them, Data Compare will handle any data size with ease.
Safe script execution, combined with variable batch and transaction size, allows for an efficient and reliable data synchronization.
Color-coding data changes makes them easy to identify.
On-Premise and Azure Support
Compare on-premise SQL Server and Azure Databases
Compare on-premise SQL Server databases, from 2000 through 2022, all editions, and Azure Databases.
Use the traditional SQL Server/Windows Authentication, or Azure Authentication with all your databases.
Use the database primary keys, constraints and unique indexes to map data rows with each other and compare them,
or create custom keys via the data compare interface when a suitable constraint/index doesn't exist.
Map the database tables/views with each other instantly, using the default mapping rules, or create custom ones and map them in any way you like.
Compare the whole data, or just a portion of it for each mapped table, by specifying where clauses.
Use the data options to control the comparison features.
Tools to Get the Job Done
GUI, Command Line, to name a few, Data Compare provides the tools you need to get the job done
Compare, script and synchronize your databases, on-premise and on the cloud, generate data differences, all interactively in a simple and intuitive interface.
Use the Data Compare Command Line to perform all the tasks the user-interface does and run these tasks in batch files.
Use the Data Compare Command Line Wizard to manage the config files of the command line utility.
Licensing Options
Data Compare can be purchased with a 1-year / per user subscription. You can choose between the Silver Subscription and the Gold Subscription.
With a subscription you get additional tools and receive all patches and updates that are released during the time that subscription is active.
In addition to the subscription licenses, we can also provide temporary extensions, subscriptions longer than 1 year, volume licensing for large organizations,
third-party sellers or virtual environments. Other licensing types may be available as well. Just send us a note at sales@xsql.com
and we will do our best to help you.
If you are looking to renew or upgrade an existing license, sign in to your account, click on the "My Licenses" link at the top bar and check the licensing renewal options that are available to you.
Data Compare supports SQL Server versions from 2000 through 2022, including the latest Azure Databases.
Requirements
Data Compare runs on Windows operating systems and requires .NET framework 4.6 or higher.
You must install also Azure Active Directory Authentication library in order to use the Azure Authentication feature.
You can download this component from Microsoft at https://www.microsoft.com/en-us/download/details.aspx?id=48742
Data Compare Editions: Licenses, Trial and Lite
Let us state, in order to avoid confusion, that there is only one package that you need to install, not three of them.
Edition is a state of Data Compare, which, depending on the licensing and the environment, could be one of the following:
Trial Mode: For the first 2 weeks after a new installation, Data Compare operates in the Trial mode. During this time, it is fully functional with no restrictions.
Lite Edition: When the 2-week trial ends, Data Compare switches to the Lite Edition if no license is found.
You can still compare SQL Server Express with no restrictions, but other SQL Server editions are limited to 25 tables and 40 views, procedures or functions (each).
Licensed Edition: It is enabled when you activate a license. The subscription license, that we provide, gives you full access to patches, updates and
all major releases that we publish during the time that your subscription is active.
We also provide free upgrade to any major build that has been released within 1 month of your purchase (subject to change).
A few additional notes on the comparison tools
For our thoughts as to why you would need the comparison tools and, most importantly, why good tools can make a big difference in your day-to-day activities,
please take a look at our database comparison tools overview page.
Click here to view the Software License Agreement.
We use cookies to ensure that you get the best experience on our website, navigate efficiently and access the website features.
By using this site, you acknowledge that you have read, understood and agree to our terms of use
and privacy policy.