|
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
