You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL developer tool editions

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

*     When the feature exists and the tool has different editions
**    First 3 licenses of ApexSQL Source Control per company, are free