You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Developer comparative matrix

All tools * – other ApexSQL Redgate®
Projects
Command line interface, automation
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 – inputs ApexSQL Redgate®
Live database
ApexSQL (proprietary) schema snapshot
Script folder
Source control project
Native backup
Source control label
3rd party backup
All tools  - outputs ApexSQL Redgate®
SQL Script
Script folder
Source control project
Database installer, package (e.g. Executable installer, C# solution)
Source control label
All tools  – integration ApexSQL Redgate®
SQL Server Management Studio (SSMS)
Visual Studio
Source control
All tools  – source control ApexSQL Redgate®
Command line support for all SC systems
Labels
Team Foundation Server (native driver) Native Native
Subversion (native driver) Native Native
Git (native driver) Native Native
Perforce (native driver) Native CLI
Mercurial (native driver) Native CLI
Data compare - ApexSQL Data Diff ApexSQL Redgate®
Custom comparison key
Reports (HTML)
Exports (Excel and CSV)
Impact analysis e.g. warnings and messages
Object mapping
Source control integration
Pre and post synchronization scripts
Decrypting - ApexSQL Decrypt ApexSQL Redgate®
Decryption scripts
SQL Server object decryption
Developer productivity - ApexSQL Complete ApexSQL Redgate®
SQL code auto-completion
Code structure viewer
Snippets
Tab navigation
Locating objects
Object definition
Object description
Tooltips
Copy query result as
Tab coloring
Test mode
Results search
Executed queries
Go to object
SQL code auto-replacements
Automatic tab renaming
Database documentation - ApexSQL Doc ApexSQL Redgate®
Server objects
Database objects
Extended property editor
XML comments (custom tags)
Dependency documentation
CHM output
HTML output
PDF output
Word (DOCX) output
Integration services (SSIS) documentation
Documentation styles
Custom descriptions via extended properties
Graphical dependencies
Analysis services (SSAS) documentation
Reporting services (SSRS) documentation
Data model diagrams
Schema compare - ApexSQL Diff ApexSQL Redgate®
Reports (HTML)
Schema mapping
Filterable difference types
Source control integration
Reports (Excel)
Exports (XML)
Pre and post synchronization scripts
Integration services (SSIS) package comparison
SQL Formatting - ApexSQL Refactor ApexSQL Redgate®
Pre-defined formatting profiles e.g. SQL Server Books Online
Batch formatting
Impact preview
Obfuscation
SQL code refactoring - ApexSQL Refactor ApexSQL Redgate®
Wildcard replacement
Split table
Safe renaming of objects
Find unused variables and parameters
Object name qualifying
Add surrogate key
Change parameters
Replace one-to-many-relationship
Copy SQL code to client code e.g. C#
Encapsulate SQL code as e.g. Procedure, Function etc
Batch refactoring (expand wildcards, qualify object names)
Search - ApexSQL Search ApexSQL Redgate®
Object search
Text search
Database analysis - ApexSQL Clean, ApexSQL Doc ApexSQL Redgate®
Graphical dependency analysis
External database analysis
Client code analysis e.g. C#, Java
Source control - ApexSQL Source Control ApexSQL Redgate®
Branching / merging
Change log
Dedicated development model
Ignore comparison and synchronization options
Labels
Migration scripts
Object locking
Object filtering
Revision history
Shared development model
Static data
Working folder
Built-in difference merging
Database development policies
Database level object status
Native driver support (vs CLI) for all popular systems
Object check out
Scripting - ApexSQL Script ApexSQL Redgate®
Data scripting
Schema scripting
Schema mapping
Source control integration
Permissions scripting 2017
Test data generation - ApexSQL Generate ApexSQL Redgate®
Pre-defined generators
Table mapping (from SQL table/view or CSV file)
Cross-column generator with built-in functions
User-defined generators
Test data generation by time
Weighted lists (custom or from file)
Regular expression generator with predefined snippets
Constraints recognition (check, unique, relationships…)
"Filler" text generators (Lorem ipsum, text shuffler, and sentence generator)
Manual Foreign key generator
Dependency viewer
Trigger based auditing - ApexSQL Trigger ApexSQL Redgate®
DDL auditing
Email alert upon changes
Auditing customization
Centralized auditing model
Auditing triggers management
Auditing reports
Auditing reports customization
Audited data management
SQL Unit testing - ApexSQL Unit Test ApexSQL Redgate®
Unit test creation
Unit test execution
Reports in XML
Build and deployment - ApexSQL Build ApexSQL Redgate®
Database deployment directly from source control
Script refactoring (for proper execution order)
Multiple script consolidation
 
 

*     When the feature exists and the tool has different versions

ApexSQL Developer

Redgate® SQL Developer Bundle


Comparison was conducted on January 4, 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