Azure SQL Database (most tools) |
|
|
Amazon RDS for SQL Server (most tools) |
|
|
SQL Server Standard and SQL Server Enterprise |
|
|
SQL Server Express (most tools) |
|
|
Source control |
|
|
SQL Server Management Studio (SSMS) |
|
|
Visual Studio |
|
|
Native or natively compressed database backup |
|
|
Schema snapshot |
|
|
Script folder |
|
|
Source control project (latest version) |
|
|
SQL Server database |
|
|
SQL script |
|
|
3rd party backup |
|
|
Source control project (changeset) |
|
|
Source control label |
|
|
Database installer, package (e.g. Executable installer, C# solution) |
|
|
Schema snapshot |
|
|
Script folder |
|
|
Source control project (latest version) |
|
|
SQL script |
|
|
Source control project (changeset) |
|
|
Source control label |
|
|
Projects |
|
|
Integrated SQL script editor |
|
|
Save project as automation script |
|
|
Authentication (Windows, SQL Server, Azure Active Directory) |
|
|
Securely saved logins |
Q2 2020 |
|
SQL Server on Linux |
|
|
Git |
Native |
Native |
Subversion |
Native |
Native |
Team Foundation Server |
Native |
Native |
Working with static data |
|
|
Mercurial |
Native |
CLI |
Perforce |
Native |
CLI |
Support all popular systems natively vs CLI |
|
|
Working with Git branches |
|
|
Working with Mercurial branches |
|
|
Working with source control labels |
|
|
Command line interface |
|
|
GUI themes |
|
|
High DPI and 4K resolution support |
|
|
Host aware theme integration |
|
|
Microsoft standard iconography, colors and other visual effects |
|
|
Accurate object dependencies |
|
|
Consolidation of multiple scripts |
|
|
Create database installers for remote updates |
|
|
Customizable builds |
|
|
Customizable properties |
|
|
Export data source (schema snapshot, scripts folder, source control project) |
|
|
Post-deployment scripts |
|
|
Refactor existing scripts for execution order |
|
|
Static data |
|
|
Transparent decryption of encrypted objects |
|
|
Archive all output files in a central folder |
|
|
Audit sensitive tables with DML triggers |
|
|
Automatically create rollback scripts |
|
|
Backup database |
[2] |
|
Build server PowerShell integration |
|
|
Check for invalid objects |
|
|
Compare production database with source control |
[2] |
|
Create deployment package |
|
|
Custom PowerShell script step |
[2] |
|
Customizable data sources |
|
|
Documentation of database changes only |
|
|
Find and mask sensitive data |
|
|
Flexible pipeline creation |
|
|
Format and obfuscate SQL code |
[2] |
|
Generate synthetic test data |
|
|
Get notified when changes are detected in source control, before a build starts |
|
|
Include static data in builds |
|
|
Native plugin (Bamboo) |
|
|
Native plugin (Jenkins) |
[2] |
|
Native plugin (Team Foundation Server / Azure DevOps) |
[2] |
|
Native plugin (TeamCity) |
|
|
Open sourced PowerShell code downloadable from GitHub |
|
|
PowerShell cmdlets |
|
|
PowerShell integration (any CI server with PowerShell support – AppVeyor, CruiseControl, GoCD, Hudson CI…) |
|
|
PowerShell integration (Octopus Deploy) |
[2] |
|
Provision test, QA, staging database from production database |
[2] |
|
Publish NuGet packages |
|
|
Report on changes |
|
|
Review database based on built-in and custom written rules |
|
|
Run SQL unit tests |
|
|
State based database delivery |
|
|
Support for advanced configuration through individual step project files |
|
|
Synchronize target database with source control |
|
|
Trigger an automated build on changes in source control |
|
|
Validate schema changes |
[2] |
|
Web dashboard |
|
|
Compare and synchronize SQL Server data |
|
|
Compare data from SSMS |
|
|
Compare data in SQL Server indexed views |
|
|
Compare database with source control project |
|
|
Compare database with SQL database backups without restoring |
|
|
Custom comparison keys for tables without PK or Unique constraints |
|
|
Data compare filters |
|
|
Export (CSV) |
|
|
Impact analysis e.g. warnings and messages |
|
|
Narrow a data comparison to affected rows only |
|
|
Object mapping |
|
|
Pre-sync action (backup destination database) |
|
|
Row level recovery from a database backup |
|
|
Schema mapping |
|
|
SQL graph support |
Q4 2019 |
|
Temporal tables support |
Q4 2019 |
|
Create a new database |
|
|
Pre-sync action (create snapshot) |
|
|
Export (Excel) |
|
|
MySQL data comparison |
Q1 2020 |
|
Perform a remote update via an executable installation package |
|
|
Pre-sync action (create rollback script) |
|
|
Pre-sync action (create script folder backup) |
|
|
Pre and post synch scripts |
|
|
Report (HTML) |
|
|
Export data to 19 data sources |
Q4 2019 |
|
Import data from 16 data sources |
Q4 2019 |
|
Option templates for export/import file formats |
Q4 2019 |
|
Pre and post deployment scripts for export data |
Q4 2019 |
|
Pre and post deployment scripts for import data |
Q4 2019 |
|
Preview data |
Q4 2019 |
|
Support for all SQL Server data types |
Q4 2019 |
|
Create masking script |
[2] |
|
Data sensitive filter (built-in) |
[2] |
|
Data sensitive filter (custom) |
[2] |
|
Data sensitive filter (import/export templates) |
[2] |
|
Enable/disable constraints and triggers |
[2] |
|
Predefined generators |
[2] |
|
Preview original and masked values |
[2] |
|
Random generator |
[2] |
|
Redaction masking |
[2] |
|
Regular expression generator |
[2] |
|
Specific value generator |
[2] |
|
Substitution column level masking |
[2] |
|
Substitution row level masking |
[2] |
|
Update live database |
[2] |
|
Dependency lists/tables |
|
|
Export diagram (EMF) |
|
|
External database analysis |
|
|
Filter, search and sort objects |
|
|
Grouping options |
|
|
Hide unreferenced objects |
|
|
Impact analysis |
|
|
Interactive visual dependencies |
|
|
Layout options |
|
|
Print diagram |
|
|
Report (PDF, XML, DOCX) |
|
|
Shape options |
|
|
Show/hide constraints and system objects |
|
|
Show/hide objects |
|
|
SQL object code |
|
|
Update all objects from schema |
|
|
Visible columns on objects |
|
|
Zoom options |
|
|
Show/hide filegroup dependencies |
|
|
Column level dependencies> |
|
|
Dependency details> |
|
|
Dependency levels> |
|
|
Export diagram (BMP, JPEG, partial selection)> |
|
|
Visible dependency types> |
|
|
Document or ignore specific SQL database or object attributes |
|
|
Documentation (schema) |
|
|
Extended property editor |
|
|
Inter-database and object dependencies |
|
|
Output (CHM, HTML, PDF, Word) |
|
|
Output (Markdown) |
Q4 2019 |
|
Personalized documentation |
|
|
SQL syntax highlighting |
|
|
Create schema snapshots |
|
|
Cross-database dependencies |
|
|
Custom descriptions via extended properties |
|
|
Data model diagrams |
|
|
Differential documentation |
|
|
Documentation (schema snapshot) |
|
|
Documentation (SharePoint) |
|
|
Documentation (SQL Server objects) |
|
|
Documentation (SSAS) |
|
|
Documentation (SSIS) |
|
|
Documentation (SSRS) |
|
|
Documentation (Tableau) |
|
|
Documentation styles |
|
|
Graphical dependencies |
|
|
Multiple source documenting |
|
|
Script decryption |
|
|
Action plan preview |
|
|
Bulk decryption |
|
|
Decryption script granularity |
|
|
Filter encrypted objects |
|
|
Alter object scripting |
|
|
Code structure viewer |
|
|
Copy query result as |
|
|
Current statement execution |
|
|
Execution alerts |
|
|
Export result grid data to Excel |
|
|
Locating objects |
|
|
Object definition |
|
|
Object description |
|
|
Snippets |
|
|
SQL code auto-completion |
|
|
Tab coloring |
|
|
Tab navigation |
|
|
Toolbar support |
|
|
Tooltips |
|
|
Code investigation |
|
|
Automatic tab renaming |
|
|
CRUD procedures |
|
|
Executed queries |
|
|
Go to object |
|
|
Results search |
|
|
SQL code auto-replacements |
|
|
Test mode |
|
|
Compare (block-by-block) |
|
|
Compare (char-by-char) |
|
|
Compare (file) |
|
|
Compare (folder) |
|
|
Compare (line-by-line) |
|
|
Compare (SQL Server object) |
|
|
Ignore script options |
|
|
Recent file list |
|
|
Report (HTML) |
|
|
Syntax highlighting |
|
|
Two-way comparison and merge |
|
|
Windows Explorer integration |
|
|
Autosave models |
|
|
Constraint customization |
Q4 2019 |
|
Create a model from a snapshot |
Q4 2019 |
|
Custom notes |
[2] |
|
Customizable script header and footer |
[2] |
|
Database modeling |
|
|
Diagram layout customization |
|
|
Edge routing customization |
|
|
Export (BMP, JPG, PNG) |
|
|
Export (partial diagram selection) |
Q4 2019 |
|
Forward engineering |
|
|
Generate SQL script from model |
Q4 2019 |
|
Index customization |
Q4 2019 |
|
Import only selected objects from database to model |
Q4 2019 |
|
Model history navigation |
|
|
Object grouping options |
|
|
Printing model diagrams |
|
|
Profiles for table customization |
Q4 2019 |
|
Reverse engineering |
|
|
Schema customization |
[2] |
|
Show/hide tables on diagrams |
Q4 2019 |
|
Error handling |
|
|
Execution (multiple scripts on multiple databases) |
|
|
Execution (parallel script on multiple databases) |
|
|
Execution (possibility of script execution on its own connection) |
|
|
Execution (selected text in a script) |
|
|
Execution (serial script on multiple databases) |
|
|
Export (CSV, TXT) |
|
|
Export (Excel) |
|
|
Pre-execution (built in script editor) |
|
|
Pre-execution (change the execution order of the scripts) |
|
|
Pre-execution (creating scripts) |
|
|
Pre-execution (database lists) |
|
|
Pre-execution (script parsing) |
|
|
Show results (grid and text layout format) |
|
|
Show results (post execution query messages) |
|
|
Show results (separate tabs for each set of results) |
|
|
Pre-execution (combine script lists) |
|
|
Pre-execution (script lists) |
|
|
Pre-execution (preview by databases or by scripts) |
|
|
Multiple violation per rule |
[2] |
|
Report (XML) |
|
|
Rule categories |
|
|
Managing rules (add, clone, delete, edit) |
|
|
Merging rulebases (importing, exporting) |
|
|
Report (HTML, FixSQL) |
|
|
Set thresholds for running process |
|
|
Automate comparison and synchronization of SQL Server database objects with a shared script folder |
|
|
Automate pulling SQL Server database objects from a shared script folder to a local database |
|
|
Automate schema snapshot archiving for change auditing |
|
|
Automate SQL Server database schemas synchronization |
|
|
Character level object differences |
|
|
Compare schemas from SSMS |
|
|
Create a new database |
Q4 2019 |
|
Deploy object changes directly from source control label |
|
|
Error-free synchronization script |
|
|
Impact analysis e.g. warnings and messages |
|
|
Include dependent database objects |
|
|
Narrow schema comparison and synchronization to affected objects only |
|
|
Pre-sync action (create snapshot script) |
|
|
Restore selected objects from a database backup without restoring |
|
|
Schema mapping |
|
|
SQL graph support |
Q4 2019 |
|
Temporal tables support |
Q4 2019 |
|
Transparent decryption of encrypted objects |
|
|
Visual filtering of schema objects |
|
|
Filterable difference codes |
|
|
MySQL schema comparison |
Q1 2020 |
|
Object mapping |
Q1 2020 |
|
Perform a remote update via an executable installation package |
|
|
Pre and post synchronization scripts |
|
|
Pre-sync action (create rollback script) |
|
|
Pre-sync action (create script folder backup) |
|
|
SSIS package comparison |
|
|
Combine objects and data in single SQL script |
|
|
Extended property editor |
|
|
Object filtering |
|
|
Permissions scripting |
|
|
Schema mapping |
|
|
Script multiple databases simultaneously |
|
|
Scripting granularity |
|
|
Navigate to object explorer node |
|
|
Object search |
|
|
Preview window |
[2] |
|
Search across several object types and databases |
|
|
Search history |
|
|
Search part of SQL object definition |
[2] |
|
Search with wildcards and booleans |
|
|
Toolbar support |
[2] |
|
View all references to an object |
|
|
Refresh search results |
|
|
Copy cell |
|
|
Copy to clipboard as CSV, Excel, HTML and XML |
|
|
Edit extended properties |
|
|
Safe rename |
|
|
Save search results as CSV, HTML and XML |
|
|
Search roles, certificates, and full-text catalogs object types |
|
|
Text search |
|
|
Built-in difference merging |
|
|
Check for dependent objects |
|
|
Commit other user changes |
|
|
Development model (Dedicated) |
|
|
Development model (Shared) |
|
|
Development policy (Optional) |
|
|
Development policy (Restrictive) |
|
|
Ignore comparison and synchronization options |
|
|
Import options to many servers/databases |
|
|
Migration scripts |
|
|
Object and project history |
|
|
Object filtering |
|
|
Object locking |
|
|
Object status check interval |
|
|
Team Foundation Server check-in policies |
|
|
View user changes |
|
|
Work item association |
|
|
SQL graph support |
|
|
Support for any system via CLI |
|
|
Branching / Merging |
|
|
Custom scripts |
|
|
Database change log |
|
|
Development policy (Permissive) |
|
|
Labels |
|
|
Merging differences - third party support |
|
|
Object change log |
|
|
Object check out without locking |
|
|
Offline mode for Git and Mercurial |
|
|
Set user default configuration |
|
|
Impact preview |
|
|
Profiles |
|
|
Skip formatting for selected code |
|
|
Quick format actions |
|
|
Batch SQL objects formatting |
|
|
Batch SQL scripts formatting |
|
|
Formatting options |
281 |
94 |
Obfuscation |
|
|
Encapsulate code as: Stored procedure |
|
|
Object name qualifying |
|
|
Rename variables and aliases |
|
|
Safe rename |
|
|
Search for invalid objects |
|
|
Search for unused parameters and variables |
|
|
Split table |
|
|
Wildcard expansion |
|
|
Add surrogate key |
|
|
Change parameters |
|
|
Convert to code |
|
|
Encapsulate code as: Scalar inline function |
|
|
Encapsulate code as: Table inline function |
|
|
Encapsulate code as: View |
|
|
Replace one-to-many-relationship |
|
|
Demo kit database with predefined unit tests |
|
|
Report (XML) |
|
|
Get messages about passed and failed SQL unit tests |
|
|
Manage all SQL unit tests from within a single form |
|
|
Multi-selection of unit tests in the "Unit test explorer" tab |
|
|
Organize SQL unit tests in test classes |
|
|
Run SQL unit tests under one class with a single click |
|
|
Run SQL unit tests with a single click |
|
|
SQL Cop tests |
|
|
Stop SQL unit test execution at any time |
|
|
Test status indicators |
|
|
Code coverage |
|
|
Customizable success thresholds |
|
|
Export (SQL database table, SQL script) |
|
|
Action plan and post-generation summary |
|
|
Auto-convert data when the source data is a different data type |
Q4 2019 |
|
Create meaningful test data with the predefined generator |
|
|
Direct execution against database |
|
|
Generate test data into graph node tables |
Q4 2019 |
|
Generator (Cross-column) |
|
|
Generator (CSV file) |
|
|
Generator (Directory) |
|
|
Generator (Disable triggers and constraints) |
|
|
Generator (Foreign key) |
|
|
Generator (Generic - random, incremental, regular expression, text shuffler) |
|
|
Generator (IronPython) |
|
|
Generator (Shareable user-defined) |
|
|
Generator (SQL query) |
|
|
Generator (SQL table or view) |
|
|
Generator (Weighted list - nested and regex) |
|
|
How to generate randomized test data from a CSV file |
|
|
Pre and post-processing scripts |
|
|
Table mapping |
|
|
Use the Seed option to recall the same random generated data |
|
|
Export (CSV, Excel, JSON, SQL script, XML) |
|
|
Generators (Predefined) |
224 |
67 |
Generators (Text - Lorem ipsum, sentence generator) |
|
|
Test data preview (CSV, Excel, JSON, SQL, XML) |
|
|
Visual dependencies |
|
|
Auditing (schema) |
|
|
Email alert upon changes |
|
|
Audited data management |
|
|
Auditing (data) |
|
|
Auditing customization |
|
|
Centralized auditing model |
|
|
Reports |
|
|
Reports customization |
|
|
Triggers management |
|
|