You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Two-way compare and merge
SSMS and Visual Studio integration
Char-by-char compare
Windows Explorer integration
Line-by-line compare
File and folder compare
Block-by-block compare
SQL Server object compare
Syntax highlighting
Ignore script options
HTML results report
Automation and scheduling

Features

Two-way comparison and merge

Compare two files and/or SQL objects and create a merge script

See next feature

SSMS and Visual Studio integration

Compare SQL Server objects directly from the Object Explorer and Server Explorer right-click context menus in SSMS and Visual Studio

See next feature

Character-level highlighting

Recognition of character-level differences and color highlighting

See next feature

Highlight colors

Color customization for difference highlights

See next feature

Three comparison modes

Choose between Character, Line, and Block comparison modes

See next feature

Ignore script options

Choose ignore options that exclude specific parts of the scripts/objects in the comparison

See next feature

Recent files quick loading

Quickly load a file from the recent files drop-down list and set the maximum items shown in the recent files list

See next feature

Folder comparison and synchronization

Use specific set of the comparison options to compare folders and synchronize files between compared folders

See next feature

ApexSQL Compare 2018 – Screen shot tour

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

How to compare two SQL scripts/objects and export comparison results

This article explains how to compare two SQL scripts/objects and export comparison results into a HTML report

ApexSQL Compare Command Line Interface (CLI) switches

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

Roadmap

Save as batch

Save current project as a batch file

Three-way comparison

Compare three SQL files/objects and create a merge script

Source control project comparison

Compare SQL objects located in source control projects

See our entire roadmap
ApexSQL Compare 2017 R1 Released ApexSQL Compare 2018 R1 Released ApexSQL Compare 2018 R2 Q4 ApexSQL Compare 2019 R1 2019 Q1
Comparison sources
File comparison
Folder comparison
SQL Server objects comparison
Source control projects comparison for:
Git
Mercurial
Perforce
Subversion
Team Foundation Server
Comparison modes
Block comparison
Character comparison
Line comparison
Two-way comparison
Three-way comparison
Word comparison
Ignore comparison options
Ansi options
Authorization
Collation
Comments
Constraint names
Filegroups
Indexes
Lock escalation
Permissions
With encryption
Case
Empty lines
Empty lines at the end of a file
Line breaks
Whitespace
Exporting
HTML report
Excel report
GUI features
Integrated file editor
Tabs option
Indentation option
Font and colors
Difference showing:
Show only conflicts
Show only different
Show only equal
Show only left
Show only mergeable
Show only right
Panel organization:
Vertical and horizontal organization
Two-pane and three-pane organization
Performance customization
Command Line Interface
Full support for Command Line Interface
Interface
GUI themes
Support for Azure SQL Database
Support for SQL Server on Amazon RDS
Support for SQL Server Management Studio 17 integration
Support for Visual Studio 2017 integration
Support for Windows Explorer integration
Support for SQL Server 2017
Save as batch
High DPI and 4K resolution support. Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied
ApexSQL Compare 2017 R1 Released ApexSQL Compare 2018 R1 Released ApexSQL Compare 2018 R2 Q4 ApexSQL Compare 2019 R1 2019 Q1

Testimonials

I am using the ApexSQL Compare to compare side by side long stored procedures and sql scripts I am writing. Very easy to use and very, very helpful! Recommended!

Periklis Kydonakis

IT Manager

Pantelis Papadopoulos SA

Other free tools

Decryption

Database object decryption

Learn more

Discovery

SQL Server instance discovery

Learn more

Formatting

SQL formatting and refactors

Learn more

Plan analysis

Query execution plan analysis

Learn more

Productivity

Improved SQL coding and productivity

Learn more

Propagation

Multi-database script execution

Learn more

Search

SQL text and object search

Learn more

Database lifecycle management (DLM)

SQL Server continuous integration (CI) and delivery (CD)

Learn more