You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Two-way compare and merge
SSMS and VS integration
Line-by-line compare
SQL script file compare
Block-by-block compare
SQL Server object compare
Syntax highlight
Ignore script options

Features

Two-way comparison and merge

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

See next feature

SSMS and VS integration

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

See next feature

Character-level highlighting

Recognition of character-level differences and color highlight

See next feature

Difference highlighting

Color customization for difference highlight

See next feature

Two comparison modes

Choose between the Line-by-line and Block-by-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 load

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

Host integration

Inherit GUI themes from SQL Server Management Studio and Visual Studio

See next feature

Resources and support

ApexSQL Compare 2017 – Screen shot tour

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

Roadmap

Command Line Interface

Full support for Command Line Interface

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 Q2 ApexSQL Compare 2017 R2 Q3 ApexSQL Compare 2017 R3 Q4
Comparison sources
SQL scripts comparison
SQL Server objects comparison
Folder comparison
Source control projects comparison
Comparison modes
Block comparison
Character comparison
Line comparison
Two-way comparison
Three-way comparison
Word-by-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
Tabs option
Indentation option
Font and colors
Difference showing:
Show only different
Show only equal
Show only left
Show only right
Show only mergeable
Show only conflicts
Panel organization:
Vertical and horizontal organization
Two-pane and three-pane organization
Integrated editor
Performance customization
Command Line Interface
Full support for Command Line Interface
Other
Support for Azure SQL Database
Support for SQL Server on Amazon RDS
Support for SQL Server Management Studio 17.0 integration
Support for Visual Studio 2017 integration
Support for Windows Explorer integration
GUI themes
Save as batch
ApexSQL Compare 2017 R1 Q2 ApexSQL Compare 2017 R2 Q3 ApexSQL Compare 2017 R3 Q4

Sharky

See all of our other
Killer free tools

Decryption

SQL Server database object decryption

Formatting

SQL formatting and refactors

Plan viewing

SQL query plan analysis and viewing

Productivity

SQL auto-complete, snippets and more

Script execution

Multi-database script execution

Search

Search SQL Server data and objects

Database lifecycle management (DLM)

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