ApexSQL Developer features 2016

Analyze and document

Graphical dependency analysis
Unused object clean up
External database analysis
Client code analysis
Server objects
Database objects
Extended property editor
XML comments (custom tags)
Dependency documentation
CHM output
HTML output
PDF output
Word (DOCX) output
Integration services documentation
Documentation styles
Custom descriptions via extended properties
Graphical dependencies
Analysis services documentation
Reporting services documentation
Database UML diagrams

Source control management

Dedicated development model
Shared development model
Object locking
Object filtering
Revision history
Change log
Static data
Working folder
Branching / merging
Native driver support
Development policies
Built-in difference merging
Labels
Migration scripts

Developer productivity

SQL code auto-completion
Code structure viewer
Snippets
Tab navigation
Locating objects
Object definition
Object description
Tooltips
Test mode
Executed queries
Go to object
Copy query result as
SQL code auto-replacements

Compare and sync

Custom comparison key
Reports
Exports
Impact analysis
Object mapping
Source control integration
Pre and post synchronization scripts
SSIS package comparison
Schema mapping
Filterable difference types

Continuous integration

Database builds from source control
Invalid objects checks
Test data generation
Unit test execution
Source control and target database synchronization
Deployment script generation

Script and build

Data scripting
Schema scripting
Schema mapping
Source control integration
Permissions scripting
Multiple database deployment
Database deployment
Script refactoring
Multiple script consolidation

Formatting and refactoring

Pre-defined formatting profiles
Batch format and refactor
Impact preview
Obfuscation
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
Encapsulate SQL code as

Test data generation

Pre-defined generators
Table mapping
Cross-column generator
User-defined generators
Test data generation by time
Weighted lists
Regular expression generator
Constraints recognition
“Lorem ipsum” text generators
Manual Foreign key generator
Dependency viewer

Unit tests

Unit test creation
Unit test execution
Reports in HTML
 

Object and text search

Object search
Text search