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)
SQL Server on Amazon RDS (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®
ApexSQL (proprietary) schema snapshot
Live database
Native backup
Script folder
Source control project
Source control label
3rd party backup
All tools  - outputs ApexSQL Redgate®
Database installer, package (e.g. Executable installer, C# solution)
Script folder
Source control project
SQL script
Source control label
All tools * – other ApexSQL Redgate®
Command line interface
Projects
Save as batch
All tools  – source control ApexSQL Redgate®
Supporting all popular systems natively vs CLI
Working with source control labels
Working with static data
Git Native Native
Subversion Native Native
Team Foundation Server Native Native
Mercurial Native CLI
Perforce Native CLI
Working with Git branches
Build and deployment - ApexSQL Build ApexSQL Redgate®
Database deployment directly from source control
Multiple script consolidation
Script refactoring (for proper execution order)
Continuous integration and delivery - ApexSQL CI/CD toolkit ApexSQL Redgate®
Archive all output files in a central folder
Automatically create rollback scripts
Build a database directly from source control
Build server PowerShell integration
Check for invalid objects
Create deployment package
Document and report on changes
Generate synthetic test data
Get notified when changes are detected in source control, before a build starts 2017 R2
Include static data in builds
Native plugins (Bamboo, Jenkins, TeamCity, TFS/VSTS) 2017 R2
PowerShell cmdlets
Publish NuGet packages 2017 R2
Run SQL unit tests
Synchronize target database with source control
Trigger an automated build on changes in source control 2017 R2
Audit sensitive tables with DML triggers
Customizable data sources
Documentation of database changes only 2017 R2
Flexible pipeline creation 2017 R2
Forecast build with a rules-based review 2017 R2
Web dashboard 2017 R2
Data comparison - ApexSQL Data Diff ApexSQL Redgate®
Custom comparison key
Data compare filters
Export (CSV)
Impact analysis e.g. warnings and messages
Object mapping
Schema mapping
Source control integration
Pre and post synchronization scripts
Report (Excel)
Reports (HTML)
Database analysis - ApexSQL Clean ApexSQL Redgate®
Graphical dependency analysis
Client code analysis e.g. C#, Java
External database analysis
Database documentation - ApexSQL Doc ApexSQL Redgate®
Database objects
Dependency documentation
Extended property editor
Server objects
XML comments (custom tags)
CHM output
HTML output
PDF output
Word (DOCX) output
Analysis services (SSAS) documentation
Custom descriptions via extended properties
Data model diagrams
Database schema snapshot documentation
Documentation styles
Graphical dependencies
Integration services (SSIS) documentation
Reporting services (SSRS) documentation
SharePoint server documentation
Tableau server documentation
SQL Server level information 2017 R8
SQL Server level properties snapshot documentation 2017 R8
Decrypting - ApexSQL Decrypt ApexSQL Redgate®
Decryption scripts
Object decryption
Developer productivity - ApexSQL Complete ApexSQL Redgate®
Code structure viewer
Copy query result as
Execution alerts
Export result grid data to Excel
Locating objects
Object definition
Object description
Snippets
SQL code auto-completion
Tab coloring
Tab navigation
Tooltips
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®
Block-by-block compare
Char-by-char compare
File compare
Folder compare
HTML report
Ignore script options
Line-by-line compare
SQL Server object compare
Syntax highlighting
Two-way comparison and merge
Modelling - ApexSQL Model ApexSQL Redgate®
Database design 2017 R1
Diagramming 2017 R1
Export diagrams (JPEG, PNG, BMP) 2017 R1
Forward engineering 2017 R1
Logical data model 2017 R1
Model comparison 2017 R1
Model conversion 2017 R1
Model synchronization 2017 R1
Physical data model 2017 R1
Reports 2017 R1
Reverse engineering 2017 R1
Visualization 2017 R1
Schema comparison - ApexSQL Diff ApexSQL Redgate®
Filterable difference types
Schema mapping
Source control integration
Export (XML)
Report (Excel)
Reports (HTML)
Create snapshot or rollback script prior to synchronization
Create script folder backup prior to synchronization
Export comparison results (SQL and database)
Integration services (SSIS) package comparison
Pre and post synchronization scripts
Scripting - ApexSQL Script ApexSQL Redgate®
Data scripting
Permissions scripting
Schema mapping
Schema scripting
Source control integration
Search - ApexSQL Search ApexSQL Redgate®
Object search
Extended properties editor
Graphical dependency analysis
Safe renaming of objects
Text search
Source control - ApexSQL Source Control ApexSQL Redgate®
Branching / merging
Change logging
Comparison and synchronization options
Dedicated development model
Local folder
Migration scripts
Object filtering
Object locking
Revision history and change rollback
Shared development model
Static data
Built-in difference merging
Checking out an object
Labels
Object status
Policies
Supporting all popular systems natively vs CLI
SQL code refactoring - ApexSQL Refactor ApexSQL Redgate®
Find unused variables and parameters
Object name qualifying
Safe renaming of objects
Split table
Wildcard replacement
Add surrogate key
Batch refactoring (expand wildcards, qualify object names)
Change parameters
Copy SQL code to client code e.g. C#
Encapsulate SQL code as e.g. Procedure, Function etc
Replace one-to-many-relationship
SQL formatting - ApexSQL Refactor ApexSQL Redgate®
Pre-defined formatting profiles e.g. SQL Server Books Online
Batch formatting
Impact preview
Obfuscation
SQL unit testing - ApexSQL Unit Test ApexSQL Redgate®
Exports (CSV, Excel) 2017
Report (XML)
Unit test creation
Unit test execution
Test data generation - ApexSQL Generate ApexSQL Redgate®
Constraints recognition (check, unique, relationships…)
Cross-column generator with built-in functions
Incremental generator
Manual Foreign key generator
Predefined generators
Regular expression generator with predefined snippets
Table mapping (from SQL table/view or CSV file)
Test data generation by time
Weighted lists (custom or from file)
Dependency viewer
Exports (XML, SQL, CSV, JSON and Excel)
"Filler" text generators (Lorem ipsum, text shuffler, and sentence generator)
Include/exclude dependent tables
User-defined generators
Trigger based auditing - ApexSQL Trigger ApexSQL Redgate®
DDL auditing
Email alert upon changes
Audited data management
Auditing customization
Auditing reports
Auditing reports customization
Auditing triggers management
Centralized auditing model
 
 

*     When the feature exists and the tool has different versions

ApexSQL Developer

Redgate® SQL Toolbelt Essentials


Comparison was conducted on June 30, 2017

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