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®
Projects
Integrated SQL script editor
Save project as automation script
All tools – connectivity ApexSQL Redgate®
Authentication (Windows, SQL Server, Azure Active Directory)
Securely saved logins 2019
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
Data from input SQL script and SQL Server database 2019
Export data source (schema snapshot, scripts folder, source control project)
Post-deployment scripts
Pre-deployment scripts 2019
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 2018 R7
Build server PowerShell integration
Check for invalid objects
Compare production database with source control 2018 R7
Create deployment package
Custom PowerShell script step 2018 R6
Customizable data sources
Documentation of database changes only
Find and mask sensitive data 2019 R2
Flexible pipeline creation
Format and obfuscate SQL code 2018 R7
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) 2018 R8
Native plugin (Team Foundation Server / Azure DevOps) 2019
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) 2019 R3
Provision test, QA, staging database from production database 2018 R7
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 2018 R7
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 2019
Temporal tables support 2019
Create a new database
Pre-sync action (create snapshot)
Export (Excel)
MySQL data comparison 2018 R7
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 2018
Export table structure 2018
Import data from 16 data sources 2018
Multi-server support 2018
Option templates for export/import file formats 2018
Post deployment scripts for export data 2018
Pre and post deployment scripts for import data 2018
Preview data 2018
Support for all SQL Server data types 2018
Task queue 2018
Task scheduler 2018
Data masking - ApexSQL Mask ApexSQL Redgate®
Configure masking rules 2018
Create a new database 2018
Data sensitive filter (custom) 2018
Data sensitive filter (default) 2018
Data sensitive filter (import/export templates) 2018
Enable/disable constraints and triggers 2018
Generate every character of the original data in XML data type columns 2018
Mask data (table level) 2018
Mask data (column level) 2018
Mask data (row level) 2018
Overwrite database and create a backup file 2018
Partial masking 2018
Preview original and masked values 2018
Save a copy of a mask script 2018
Shuffle masked data in each column separately 2018
Database analysis - ApexSQL Analyze ApexSQL Redgate®
Dependency lists/tables
Export diagram (EMF) 2019 R2
External database analysis 2019 R2
Filter, search and sort objects
Grouping options
Hide unreferenced objects
Impact analysis
Interactive visual dependencies
Layout options
Print diagram 2019 R2
Report (PDF, XML) 2019 R2
Shape options
Show/hide constraints and system objects 2019
Show/hide objects
SQL object code
Update all objects from schema 2019 R2
Visible columns on objects
Zoom options
Show/hide filegroup dependencies
Column level dependencies 2019 R2
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
Document SQL graph tables 2019 R2
Documentation (schema)
Extended property editor
Inter-database and object dependencies
Output (CHM, HTML, PDF, Word)
Output (Markdown) 2019 R2
Personalized documentation
SQL syntax highlighting
Create schema snapshots
Cross-database dependencies
Custom descriptions via extended properties
Data model diagrams
Differential documentation
Documentation (MySQL) 2019 R2
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 2019
Execution alerts
Export result grid data to Excel
Locating objects
Object definition
Object description
Snippets
SQL code auto-completion
Tab coloring
Tab navigation
Toolbar support
Tooltips
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
Custom notes 2018 R2
Customizable script header and footer 2018 R2
Database modeling
Diagram layout customization
Edge routing customization
Export (BMP, JPG, PNG)
Export ( partial diagram selection)
Forward engineering
Index customization 2019
Model history navigation
Object grouping options
Printing model diagrams
Reverse engineering
Schema customization 2018 R2
Multi-DB SQL script execution - ApexSQL Propagate [1] ApexSQL Redgate®
Error handling
Execution (multiple scripts on multiple databases)
Execution (parallel script on multiple databases) 2019
Execution (possibility of script execution on its own connection) 2019
Execution (selected text in a script) 2019
Execution (serial script on multiple databases)
Export (CSV, TXT)
Export (Excel, XML) 2019
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) 2019
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 2018 R4
Report (XML)
Rule categories
Duplicate code finder for object pairs, objects and script blocks 2019
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 2019
Deploy object changes directly from source control label
Error-free synchronization script
Examine differences using the summary view 2019
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 2019
Temporal tables support 2019
Transparent decryption of encrypted objects
Visual filtering of schema objects
Filterable difference codes
MySQL schema comparison 2019
Object mapping 2019
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 2019
Search across several object types and databases
Search history
Search part of SQL object definition 2019
Search with wildcards and booleans
Toolbar support 2019
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
SQL graph support 2018 R9
Team Foundation Server check-in policies
View user changes
Work item association
Support for any system via CLI
Branching / Merging
Custom scripts
Database change log
Development policy (Permissive)
Labels
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
Profiles
Skip formatting for selected code 2019
Quick format actions
Batch SQL objects formatting
Batch SQL scripts formatting
Formatting options 281 94
Obfuscation
SQL code refactoring - ApexSQL Refactor ApexSQL Redgate®
Encapsulate code as: Stored procedure
Object name qualifying
Rename variables and aliases 2019
Safe rename
Search for invalid objects 2019
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 2019
Between-column dependency support 2019
Create meaningful test data with the predefined generator
Direct execution against database
Generate test data into graph node tables 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
Reports customization
Triggers management
 
 

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

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