You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Compare data in live DBs, backups and SC projects
Perform row level recovery without restoring
Community, Standard, and Professional editions
Compare huge databases quickly and without errors
Automate and schedule data migrations
Initiate database compares directly from SSMS
Export results to HTML, CSV and Excel
Create executable installation packages
Integrate with all popular SC systems e.g. Git, SVN
Deploy data changes directly from a source control label

Features

Row level recovery from backups

Compare SQL database backups without restoring. Granularly restore data down to the row level. Learn more

See next feature

SSMS integration

Compare SQL database data directly from SQL Server Management Studio

See next feature

Key-independent comparison

Use a custom comparison key to compare data in tables without a primary key or UNIQUE constraints. Learn more

See next feature

Object mapping

Compare data in different SQL objects with different names and schemas using object mapping. Learn more

See next feature

Schema mapping

Compare SQL objects with different users. Learn more

See next feature

Data filters

Selectively limit what will be compared and synchronized with data level filtering. Learn more

See next feature

Custom script support

Augment the deployment script with your own pre or post synchronization scripts

See next feature

Extensive configuration options

Customize comparison and synchronization options

See next feature

Reporting

Export SQL data comparison results to several different types of HTML reports. Learn more

See next feature

Data level reports

Create HTML reports showing all data differences between two compared tables. Learn more

See next feature

Excel report

Export the comparison results to Excel

See next feature

Object filter editor

Build complex filters to compare and synchronize specific objects

See next feature

Repeatable sessions

Save your settings to a project for re-execution of the same session

See next feature

Native IDE

Use the built in SQL editor to review and edit scripts prior to execution

See next feature

Source control integration

Including Git, Mercurial, Perforce, Subversion, and Team Foundation Server

See next feature

Script folder

Compare data from local script folders against a database or source control project

See next feature

Advantages of ApexSQL Data Diff vs. Visual Studio®

This article describes features which are available in ApexSQL Data Diff and which don’t exist in Visual Studio®

ApexSQL Data Diff 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Data Diff features with a brief description

Automatically compare and synchronize SQL Server data

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

Synchronize SQL Server databases in different remote sources

This article describes how to synchronize SQL Server databases on remote locations with a SQL Server database in the datacenter using ApexSQL Data Diff

SQL Server bulk copy and bulk import and export techniques

This article explains how to copy large amounts of data from one table or set of tables to other databases

How to compare SQL Server database tables with different names

This article describes how to use the Object mapping feature to compare SQL Server database tables with different names

ApexSQL Data Diff Command Line Interface (CLI) switches

This article explains the ApexSQL Data Diff CLI switches, and their usage through the examples

See more
ApexSQL Redgate®
Community Standard Professional Standard Pro
SQL Server version
      SQL Server 2005 - 2017
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Azure SQL Database
      Amazon RDS for SQL Server
Integration
      SQL Server Management Studio (SSMS)
      Visual Studio
Inputs
      Native or natively compressed database backup
      Script folder
      Source control project (latest version)
      SQL Server database
      3rd party backup
      Source control project (changeset)
      MySQL database 2018 R7 2018 R7 2018 R7
      Source control label
Outputs
      Direct execution against database (synchronization)
      Script folder (synchronization)
      Source control project (latest version synchronization)
      SQL script
      Source control project (changeset synchronization)
      Database installer package (e.g. Executable installer, C# solution)
      Source control label (synchronization)
Reports and exports
      CSV export
      Excel export
      HTML export
Comparison
      Custom comparison keys for tables without PK or Unique constraints
      Data compare filters
      Impact analysis e.g. warnings and messages
      Object mapping
      Schema mapping
      MySQL data comparison 2018 R7 2018 R7 2018 R7
Pre-sync actions
      Backup destination database
      Create snapshot
      Create rollback script
      Create script folder backup
      Pre and post synchronization scripts
Source control system support
      Subversion Native Native
      Team Foundation Server Native Native
      Git Native CLI
      Mercurial Native CLI
      Perforce Native CLI
Connectivity
      Azure Active Directory authentication
      Securely saved logins 2019 2019 2019
      SQL Server on Linux
Other
      Projects
      Retention tables support 2019 2019 2019
      SQL Graph support 2019 2019 2019
      Temporal tables support 2019 2019 2019
      Create a new database
      Integrated SQL script editor
      Save project as automation script
      Task scheduler 2018 R7
Use cases
      Compare and synchronize SQL Server data
      Compare data in SQL Server indexed views
      Compare data from SSMS
      Compare database with source control project
      Compare database with SQL database backups without restoring
      Narrow a data comparison to affected rows only
      Row level recovery from a database backup
      Perform a remote update via an executable installation package
Interface
      Command line interface
      GUI themes
      High DPI and 4K resolution support
      Host aware theme adoption
      Microsoft standard iconography, colors and other visual effects
Price (Qty)
      1 Free $399 $599 $495 $745
      3 Free $319 $479 $495 $745
      5 Free $279 $419 $421 $633
      10 Free $239 $359 $396 $596

ApexSQL Data Diff 2018.05

Redgate® SQL Data Compare 13.4.7.7337


Comparison was conducted on September 06, 2018

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

Testimonials

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. Apex 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 Apex for helping us out!

Steve Groner

Riverside Senior SQ 5

Civil Air Patrol, Pacific Region

ApexSQL Data Diff is part of the

ApexSQL DevOps toolkit

Volume pricing

Standard

1

$399

2-4

$319

5-9

$279

10-19

$239

Professional

1

$599

2-4

$479

5-9

$419

10-19

$359

Save a bundle

ApexSQL Data Diff is included in ApexSQL Developer

All 20 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 80%+ savings