You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts


ApexSQL Developer comparative matrix

All tools – data sources ApexSQL Redgate®
Azure SQL Database (most tools)
Amazon RDS for SQL Server (most tools)
SQL Server Standard and SQL Server Enterprise
SQL Server Express (most tools)
All tools  – integration ApexSQL Redgate®
Source control
SQL Server Management Studio (SSMS)
Visual Studio
All tools – inputs ApexSQL Redgate®
Native or natively compressed database backup
Schema snapshot
Script folder
Source control project (latest version)
SQL Server database
SQL script
3rd party backup
Source control project (changeset)
Source control label
All tools  - outputs ApexSQL Redgate®
Database installer, package (e.g. Executable installer, C# solution)
Schema snapshot
Script folder
Source control project (latest version)
SQL script
Source control project (changeset)
Source control label
All tools – other ApexSQL Redgate®
Integrated SQL script editor
Save project as automation script
All tools – connectivity ApexSQL Redgate®
Authentication (Windows, SQL Server, Azure Active Directory)
Securely saved logins Q2 2020
SQL Server on Linux
All tools – source control ApexSQL Redgate®
Git Native Native
Subversion Native Native
Team Foundation Server Native Native
Working with static data
Mercurial Native CLI
Perforce Native CLI
Support all popular systems natively vs CLI
Working with Git branches
Working with Mercurial branches
Working with source control labels
All tools  – interface ApexSQL Redgate®
Command line interface
GUI themes
High DPI and 4K resolution support
Host aware theme integration
Microsoft standard iconography, colors and other visual effects
Build and deployment - ApexSQL Build ApexSQL Redgate®
Accurate object dependencies
Consolidation of multiple scripts
Create database installers for remote updates
Customizable builds
Customizable properties
Export data source (schema snapshot, scripts folder, source control project)
Post-deployment scripts
Refactor existing scripts for execution order
Static data
Transparent decryption of encrypted objects
Continuous integration and delivery - ApexSQL DevOps toolkit ApexSQL Redgate®
Archive all output files in a central folder
Audit sensitive tables with DML triggers
Automatically create rollback scripts
Backup database [2]
Build server PowerShell integration
Check for invalid objects
Compare production database with source control [2]
Create deployment package
Custom PowerShell script step [2]
Customizable data sources
Documentation of database changes only
Find and mask sensitive data
Flexible pipeline creation
Format and obfuscate SQL code [2]
Generate synthetic test data
Get notified when changes are detected in source control, before a build starts
Include static data in builds
Native plugin (Bamboo)
Native plugin (Jenkins) [2]
Native plugin (Team Foundation Server / Azure DevOps) [2]
Native plugin (TeamCity)
Open sourced PowerShell code downloadable from GitHub
PowerShell cmdlets
PowerShell integration (any CI server with PowerShell support – AppVeyor, CruiseControl, GoCD, Hudson CI…)
PowerShell integration (Octopus Deploy) [2]
Provision test, QA, staging database from production database [2]
Publish NuGet packages
Report on changes
Review database based on built-in and custom written rules
Run SQL unit tests
State based database delivery
Support for advanced configuration through individual step project files
Synchronize target database with source control
Trigger an automated build on changes in source control
Validate schema changes [2]
Web dashboard
Data comparison and synchronization - ApexSQL Data Diff ApexSQL Redgate®
Compare and synchronize SQL Server data
Compare data from SSMS
Compare data in SQL Server indexed views
Compare database with source control project
Compare database with SQL database backups without restoring
Custom comparison keys for tables without PK or Unique constraints
Data compare filters
Export (CSV)
Impact analysis e.g. warnings and messages
Narrow a data comparison to affected rows only
Object mapping
Pre-sync action (backup destination database)
Row level recovery from a database backup
Schema mapping
SQL graph support Q4 2019
Temporal tables support Q4 2019
Create a new database
Pre-sync action (create snapshot)
Export (Excel)
MySQL data comparison Q1 2020
Perform a remote update via an executable installation package
Pre-sync action (create rollback script)
Pre-sync action (create script folder backup)
Pre and post synch scripts
Report (HTML)
Data import and export - ApexSQL Pump ApexSQL Redgate®
Export data to 19 data sources Q4 2019
Import data from 16 data sources Q4 2019
Option templates for export/import file formats Q4 2019
Pre and post deployment scripts for export data Q4 2019
Pre and post deployment scripts for import data Q4 2019
Preview data Q4 2019
Support for all SQL Server data types Q4 2019
Data masking - ApexSQL Mask ApexSQL Redgate®
Create masking script [2]
Data sensitive filter (built-in) [2]
Data sensitive filter (custom) [2]
Data sensitive filter (import/export templates) [2]
Enable/disable constraints and triggers [2]
Predefined generators [2]
Preview original and masked values [2]
Random generator [2]
Redaction masking [2]
Regular expression generator [2]
Specific value generator [2]
Substitution column level masking [2]
Substitution row level masking [2]
Update live database [2]
Database analysis - ApexSQL Analyze ApexSQL Redgate®
Dependency lists/tables
Export diagram (EMF)
External database analysis
Filter, search and sort objects
Grouping options
Hide unreferenced objects
Impact analysis
Interactive visual dependencies
Layout options
Print diagram
Report (PDF, XML, DOCX)
Shape options
Show/hide constraints and system objects
Show/hide objects
SQL object code
Update all objects from schema
Visible columns on objects
Zoom options
Show/hide filegroup dependencies
Column level dependencies
Dependency details
Dependency levels
Export diagram (BMP, JPEG, partial selection)
Visible dependency types
Database, BI, SharePoint and Tableau documentation - ApexSQL Doc ApexSQL Redgate®
Document or ignore specific SQL database or object attributes
Documentation (schema)
Extended property editor
Inter-database and object dependencies
Output (CHM, HTML, PDF, Word)
Output (Markdown) Q4 2019
Personalized documentation
SQL syntax highlighting
Create schema snapshots
Cross-database dependencies
Custom descriptions via extended properties
Data model diagrams
Differential documentation
Documentation (schema snapshot)
Documentation (SharePoint)
Documentation (SQL Server objects)
Documentation (SSAS)
Documentation (SSIS)
Documentation (SSRS)
Documentation (Tableau)
Documentation styles
Graphical dependencies
Multiple source documenting
Decrypting - ApexSQL Decrypt ApexSQL Redgate®
Script decryption
Action plan preview
Bulk decryption
Decryption script granularity
Filter encrypted objects
Developer productivity - ApexSQL Complete ApexSQL Redgate®
Alter object scripting
Code structure viewer
Copy query result as
Current statement execution
Execution alerts
Export result grid data to Excel
Locating objects
Object definition
Object description
SQL code auto-completion
Tab coloring
Tab navigation
Toolbar support
Code investigation
Automatic tab renaming
CRUD procedures
Executed queries
Go to object
Results search
SQL code auto-replacements
Test mode
File and folder compare - ApexSQL Compare ApexSQL Redgate®
Compare (block-by-block)
Compare (char-by-char)
Compare (file)
Compare (folder)
Compare (line-by-line)
Compare (SQL Server object)
Ignore script options
Recent file list
Report (HTML)
Syntax highlighting
Two-way comparison and merge
Windows Explorer integration
Modeling - ApexSQL Model ApexSQL Redgate®
Autosave models
Constraint customization Q4 2019
Create a model from a snapshot Q4 2019
Custom notes [2]
Customizable script header and footer [2]
Database modeling
Diagram layout customization
Edge routing customization
Export (BMP, JPG, PNG)
Export (partial diagram selection) Q4 2019
Forward engineering
Generate SQL script from model Q4 2019
Index customization Q4 2019
Import only selected objects from database to model Q4 2019
Model history navigation
Object grouping options
Printing model diagrams
Profiles for table customization Q4 2019
Reverse engineering
Schema customization [2]
Show/hide tables on diagrams Q4 2019
Multi-DB SQL script execution - ApexSQL Propagate [1] ApexSQL Redgate®
Error handling
Execution (multiple scripts on multiple databases)
Execution (parallel script on multiple databases)
Execution (possibility of script execution on its own connection)
Execution (selected text in a script)
Execution (serial script on multiple databases)
Export (CSV, TXT)
Export (Excel)
Pre-execution (built in script editor)
Pre-execution (change the execution order of the scripts)
Pre-execution (creating scripts)
Pre-execution (database lists)
Pre-execution (script parsing)
Show results (grid and text layout format)
Show results (post execution query messages)
Show results (separate tabs for each set of results)
Pre-execution (combine script lists)
Pre-execution (script lists)
Pre-execution (preview by databases or by scripts)
Rules based enforcement - ApexSQL Enforce ApexSQL Redgate®
Multiple violation per rule [2]
Report (XML)
Rule categories
Managing rules (add, clone, delete, edit)
Merging rulebases (importing, exporting)
Report (HTML, FixSQL)
Set thresholds for running process
Schema comparison and synchronization - ApexSQL Diff ApexSQL Redgate®
Automate comparison and synchronization of SQL Server database objects with a shared script folder
Automate pulling SQL Server database objects from a shared script folder to a local database
Automate schema snapshot archiving for change auditing
Automate SQL Server database schemas synchronization
Character level object differences
Compare schemas from SSMS
Create a new database Q4 2019
Deploy object changes directly from source control label
Error-free synchronization script
Impact analysis e.g. warnings and messages
Include dependent database objects
Narrow schema comparison and synchronization to affected objects only
Pre-sync action (create snapshot script)
Restore selected objects from a database backup without restoring
Schema mapping
SQL graph support Q4 2019
Temporal tables support Q4 2019
Transparent decryption of encrypted objects
Visual filtering of schema objects
Filterable difference codes
MySQL schema comparison Q1 2020
Object mapping Q1 2020
Perform a remote update via an executable installation package
Pre and post synchronization scripts
Pre-sync action (create rollback script)
Pre-sync action (create script folder backup)
SSIS package comparison
Scripting - ApexSQL Script ApexSQL Redgate®
Combine objects and data in single SQL script
Extended property editor
Object filtering
Permissions scripting
Schema mapping
Script multiple databases simultaneously
Scripting granularity
Search - ApexSQL Search ApexSQL Redgate®
Navigate to object explorer node
Object search
Preview window [2]
Search across several object types and databases
Search history
Search part of SQL object definition [2]
Search with wildcards and booleans
Toolbar support [2]
View all references to an object
Refresh search results
Copy cell
Copy to clipboard as CSV, Excel, HTML and XML
Edit extended properties
Safe rename
Save search results as CSV, HTML and XML
Search roles, certificates, and full-text catalogs object types
Text search
Source control - ApexSQL Source Control ApexSQL Redgate®
Built-in difference merging
Check for dependent objects
Commit other user changes
Development model (Dedicated)
Development model (Shared)
Development policy (Optional)
Development policy (Restrictive)
Ignore comparison and synchronization options
Import options to many servers/databases
Migration scripts
Object and project history
Object filtering
Object locking
Object status check interval
Team Foundation Server check-in policies
View user changes
Work item association
SQL graph support
Support for any system via CLI
Branching / Merging
Custom scripts
Database change log
Development policy (Permissive)
Merging differences - third party support
Object change log
Object check out without locking
Offline mode for Git and Mercurial
Set user default configuration
SQL code formatting - ApexSQL Refactor ApexSQL Redgate®
Impact preview
Skip formatting for selected code
Quick format actions
Batch SQL objects formatting
Batch SQL scripts formatting
Formatting options 281 94
SQL code refactoring - ApexSQL Refactor ApexSQL Redgate®
Encapsulate code as: Stored procedure
Object name qualifying
Rename variables and aliases
Safe rename
Search for invalid objects
Search for unused parameters and variables
Split table
Wildcard expansion
Add surrogate key
Change parameters
Convert to code
Encapsulate code as: Scalar inline function
Encapsulate code as: Table inline function
Encapsulate code as: View
Replace one-to-many-relationship
SQL unit testing - ApexSQL Unit Test ApexSQL Redgate®
Demo kit database with predefined unit tests
Report (XML)
Get messages about passed and failed SQL unit tests
Manage all SQL unit tests from within a single form
Multi-selection of unit tests in the "Unit test explorer" tab
Organize SQL unit tests in test classes
Run SQL unit tests under one class with a single click
Run SQL unit tests with a single click
SQL Cop tests
Stop SQL unit test execution at any time
Test status indicators
Code coverage
Customizable success thresholds
Export (SQL database table, SQL script)
Test data generation - ApexSQL Generate ApexSQL Redgate®
Action plan and post-generation summary
Auto-convert data when the source data is a different data type Q4 2019
Create meaningful test data with the predefined generator
Direct execution against database
Generate test data into graph node tables Q4 2019
Generator (Cross-column)
Generator (CSV file)
Generator (Directory)
Generator (Disable triggers and constraints)
Generator (Foreign key)
Generator (Generic - random, incremental, regular expression, text shuffler)
Generator (IronPython)
Generator (Shareable user-defined)
Generator (SQL query)
Generator (SQL table or view)
Generator (Weighted list - nested and regex)
How to generate randomized test data from a CSV file
Pre and post-processing scripts
Table mapping
Use the Seed option to recall the same random generated data
Export (CSV, Excel, JSON, SQL script, XML)
Generators (Predefined) 224 67
Generators (Text - Lorem ipsum, sentence generator)
Test data preview (CSV, Excel, JSON, SQL, XML)
Visual dependencies
Trigger based SQL auditing - ApexSQL Trigger ApexSQL Redgate®
Auditing (schema)
Email alert upon changes
Audited data management
Auditing (data)
Auditing customization
Centralized auditing model
Reports customization
Triggers management

[1] ApexSQL Propagate is a free tool available individually or as a part of the ApexSQL DBA bundle

[2] Implemented after the below comparison date

ApexSQL Developer

Redgate® SQL Toolbelt Essentials

Comparison was conducted on August 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

© 2019 Quest Software Inc. ALL RIGHTS RESERVED.   |   1-800-306-9329   |   |   GDPR   |   Terms of Use   |   Privacy