ApexSQL Developer features 2017

ApexSQL Developer features - periodic table

Analysis

Column level dependencies
Object dependencies
Impact analysis
Graphical dependency
analysis
External database
analysis

Scripting and building

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

Documentation

XML comments
Column level dependencies
Dependency documentation
Graphical dependencies
Analysis services
Reporting services
Integration services
SharePoint documentation
Data dictionary
Documentation styles
Custom descriptions
Database UML diagrams
Server properties
Database objects
Extended property editor
Tableau Server
documentation
SQL Server
documentation

Modeling

Logical data model
Physical data model
Design database
Reports
Visualization
Diagraming
Exports
Reverse engineering
Forward engineering
Synchronize model
Compare model
Convert model

Data I/O

Export data
Import data
Export data preview
Import data preview
Error handling
Option templates

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

Rule enforcement

Rule editor
Summary reports
Command line interface
Custom severities
Failure thresholds
Built-in rulebase
SQL Server rules
Database object rules
Script-based rules

Developer productivity

Local database cache
SQL code auto-completion
Code structure viewer
Snippets
Tab navigation
Locating objects
Object definition
Executed query archive
Clipboard snippet
Automatic tab renaming
Search result grid
Multiple server hints
Query to file
Tab coloring
Execution alerts
Resume work
Nested snippet
Object description
Tooltips
Test mode
Executed queries
Procedure generator
Database specific
connection excludes
Delete history option
Go to object
Copy query result as
SQL code auto-replacements

Comparison and
synchronization

HTML reports
CSV, XML exports
Impact analysis
Object mapping
Script folder comparison
Executable
installation packages
SSIS package comparison
Schema mapping
Filterable difference types
SSAS package comparison
CLI automation
Source control integration
Pre and post synchronization scripts
Custom comparison keys
Data dictionary
SQL Server compare

Object decryption

Decrypt from multiple servers
Filter objects
Exports scripts
SSMS integration

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
Automatic build trigger
CI vendor integration
Build step
Data generation step
Test step
Audit step
Review step
Synchronization step

Unit testing

Unit test creation
Demo kit
Exports
Success thresholds
SQL Cop tests

Formatting and refactoring

Pre-defined formatting profiles
Batch formatting and refactoring
Impact preview
Obfuscation
Wildcard replacement
Split table
Safe renaming of objects
Find unused variables
Object name qualifying
Add surrogate key
Change parameters
Replace one-to-many-relationship
Copy SQL code to client code
Encapsulate SQL code as

Object and text search

Object search
Text search

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

* Some listed products and features are planned for 2017

 

January 6, 2017