Bi-weekly updates
Exclusive discounts
Product update alerts
Join 120,000+ subscribers
Compare SQL data from live databases, scripts, backups and source control
Compare SQL database backups without restoring. Granularly restore data down to the row level. Learn more
Compare SQL data directly from the Object Explorer and Server Explorer right-click context menus in SSMS and Visual Studio
Use a custom comparison key to compare data in tables without a primary key or UNIQUE constraints. Learn more
Compare data in different SQL objects with different names and schemas using object mapping. Learn more
Compare SQL objects with different users. Learn more
Selectively limit what will be compared and synchronized with data level filtering. Learn more
Augment the deployment script with your own pre or post synchronization scripts
Customize comparison and synchronization options
Export SQL data comparison results to several different types of HTML reports. Learn more
Create HTML reports showing all data differences between two compared tables. Learn more
Export the comparison results to Excel
Build complex filters to compare and synchronize specific objects
Save your settings to a project for re-execution of the same session
Use the built in SQL editor to review and edit scripts prior to execution
Including Git, Mercurial, Perforce, Subversion, and Team Foundation Server
Compare data from local script folders against a database or source control project
Customize the visual appearance with interface themes. Learn more
This article represents a screen shot tour of ApexSQL Data Diff features with a brief description
This article describes features which are available in ApexSQL Data Diff and which don’t exist in Visual Studio®
This article describes how to use ApexSQL Data Diff to set all synchronization options, map tables and columns with different names, create your own keys for comparison in the GUI and schedule it to run unattended
This article describes how to synchronize SQL Server databases on remote locations with a SQL Server database in the datacenter using ApexSQL Data Diff
This article explains how to copy large amounts of data from one table or set of tables to other databases
This article describes how to use the Object mapping feature to compare SQL Server database tables with different names
This article explains the ApexSQL Data Diff CLI switches, and their usage through the examples
ApexSQL Data Diff 2019.01
Redgate® SQL Data Compare 14.1.9.14719
Comparison was conducted on January 24, 2020
Disclaimer: All product and company names are trademarks™ or registered® trademarks of their respective holders. ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates
We have fully integrated ApexSQL Diff and ApexSQL Data Diff into our design, integration/ performance testing, and production release SDLC. The ApexSQL tools have tremendously increased our confidence level on the integration of these systems and the veracity of our product release cycles. ApexSQL Data Diff allowed us to proof test the automation of a ETL process against the long standing manual process that was in use in production, and when that system goes into full production, will save our company hundreds of thousands of dollars over the next few years, and millions in the years to come
William E. Saxon, Jr.
T Consultant - Application Development
Nationwide Better Health
We are a startup HIS company that provides a hosted solution for hospital Clinical Diagnostic Information. The requirements are such that we needed a comprehensive Structure and Data Diff/Update tool for our sometimes complex updates. ApexSQL Diff and ApexSQL Data Diff have been nothing short of miraculous in performing diffs and providing upgrade scripts. Even a difficult update with table, column and key name changes showed a lot of intelligent programming went into these tools. Highly recommended
Martin Bradburn
Principle DBA
ChartWise Medical Systems
I am with my third company using your ApexSQL tools. Brian, over the years it I have always appreciated that you see and respond personally to the Email & Forum traffic ApexSQL Diff still rocks and splitting out ApexSQL Data Diff was definitely a step in the right direction
David M. Carpenter
Senior Application Developer
CareMedic Systems Inc.
ApexSQL Data Diff is a lovely tool assisting me in ensuring that development servers always have the latest essential test data from production databases.
Robert Blomstrand
Senior Database and .Net Developer Consultant
Exabyte Development
ApexSQL Data Diff is a wonderful tool, we used it few years, and helped us successfully transferring database changes to clients.
Michael Tian
Senior SQL Server Database Administrator
ELM, a Wolters Kluwer business
When maintaining and updating our customers’ databases we find ApexSQL Data Diff to be reliable and always deliver an excellent and flawless result.
Henrik Jirner
System architect
Q enter AB
I must say that ApexSQL Data Diff CLI is extremely helpful. Keep up the great work.
Willie Myburgh
Senior Database Administrator
Verifaction Software
I want you and your team to know that the SQL Data Diff tool is awesome. That tool saved my $$ last year when I had to identify missing data in a Production database. It would have taken me hours to write the same T-SQL to make the same comparisons. Your tool allowed me to quickly install, and then point at two sources to see what was missing. I was able to quickly identify the data discrepancies, and then get the data back in. I really appreciate this more than you might realize :-)
Paul Wimmer, MSc.
Owner/Software Architect
Lambda Sigma Tech LLC
Civil Air Patrol had a need for an easy to use, quality tool to solve a Microsoft SQL data/schema synchronization issue. ApexSQL by far was the tool for us. It allowed us to quickly complete the project and allowed us to incorporate automation to allow us to keep that data in sync. This is an awesome tool with excellent customer service to support it. Thanks ApexSQL for helping us out!
Steve Groner
Riverside Senior SQ 5
Civil Air Patrol, Pacific Region
ApexSQL Data Diff is part of the
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy