| 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 |
2019 |
|
| 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 |
|
|
| Data from input SQL script and SQL Server database |
2019 |
|
| Export data source (schema snapshot, scripts folder, source control project) |
|
|
| Post-deployment scripts |
|
|
| Pre-deployment scripts |
2019 |
|
| 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 |
2018 R7 |
|
| Build server PowerShell integration |
|
|
| Check for invalid objects |
|
|
| Compare production database with source control |
2018 R7 |
|
| Create deployment package |
|
|
| Custom PowerShell script step |
2018 R6 |
|
| Customizable data sources |
|
|
| Documentation of database changes only |
|
|
| Find and mask sensitive data |
2019 R2 |
|
| Flexible pipeline creation |
|
|
| Format and obfuscate SQL code |
2018 R7 |
|
| 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) |
2018 R8 |
|
| Native plugin (Team Foundation Server / Azure DevOps) |
2019 |
|
| 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) |
2019 R3 |
|
| Provision test, QA, staging database from production database |
2018 R7 |
|
| 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 |
2018 R7 |
|
| 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 |
2019 |
|
| Temporal tables support |
2019 |
|
| Create a new database |
|
|
| Pre-sync action (create snapshot) |
|
|
| Export (Excel) |
|
|
| MySQL data comparison |
2018 R7 |
|
| 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 |
2018 |
|
| Export table structure |
2018 |
|
| Import data from 16 data sources |
2018 |
|
| Multi-server support |
2018 |
|
| Option templates for export/import file formats |
2018 |
|
| Post deployment scripts for export data |
2018 |
|
| Pre and post deployment scripts for import data |
2018 |
|
| Preview data |
2018 |
|
| Support for all SQL Server data types |
2018 |
|
| Task queue |
2018 |
|
| Task scheduler |
2018 |
|
| Configure masking rules |
2018 |
|
| Create a new database |
2018 |
|
| Data sensitive filter (custom) |
2018 |
|
| Data sensitive filter (default) |
2018 |
|
| Data sensitive filter (import/export templates) |
2018 |
|
| Enable/disable constraints and triggers |
2018 |
|
| Generate every character of the original data in XML data type columns |
2018 |
|
| Mask data (table level) |
2018 |
|
| Mask data (column level) |
2018 |
|
| Mask data (row level) |
2018 |
|
| Overwrite database and create a backup file |
2018 |
|
| Partial masking |
2018 |
|
| Preview original and masked values |
2018 |
|
| Save a copy of a mask script |
2018 |
|
| Shuffle masked data in each column separately |
2018 |
|
| Dependency lists/tables |
|
|
| Export diagram (EMF) |
2019 R2 |
|
| External database analysis |
2019 R2 |
|
| Filter, search and sort objects |
|
|
| Grouping options |
|
|
| Hide unreferenced objects |
|
|
| Impact analysis |
|
|
| Interactive visual dependencies |
|
|
| Layout options |
|
|
| Print diagram |
2019 R2 |
|
| Report (PDF, XML) |
2019 R2 |
|
| Shape options |
|
|
| Show/hide constraints and system objects |
2019 |
|
| Show/hide objects |
|
|
| SQL object code |
|
|
| Update all objects from schema |
2019 R2 |
|
| Visible columns on objects |
|
|
| Zoom options |
|
|
| Show/hide filegroup dependencies |
|
|
| Column level dependencies |
2019 R2 |
|
| Dependency details |
|
|
| Dependency levels |
|
|
| Export diagram (BMP, JPEG, partial selection) |
|
|
| Visible dependency types |
|
|
| Document or ignore specific SQL database or object attributes |
|
|
| Document SQL graph tables |
2019 R2 |
|
| Documentation (schema) |
|
|
| Extended property editor |
|
|
| Inter-database and object dependencies |
|
|
| Output (CHM, HTML, PDF, Word) |
|
|
| Output (Markdown) |
2019 R2 |
|
| Personalized documentation |
|
|
| SQL syntax highlighting |
|
|
| Create schema snapshots |
|
|
| Cross-database dependencies |
|
|
| Custom descriptions via extended properties |
|
|
| Data model diagrams |
|
|
| Differential documentation |
|
|
| Documentation (MySQL) |
2019 R2 |
|
| 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 |
2019 |
|
| 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 |
|
|
| Custom notes |
2018 R2 |
|
| Customizable script header and footer |
2018 R2 |
|
| Database modeling |
|
|
| Diagram layout customization |
|
|
| Edge routing customization |
|
|
| Export (BMP, JPG, PNG) |
|
|
| Export ( partial diagram selection) |
|
|
| Forward engineering |
|
|
| Index customization |
2019 |
|
| Model history navigation |
|
|
| Object grouping options |
|
|
| Printing model diagrams |
|
|
| Reverse engineering |
|
|
| Schema customization |
2018 R2 |
|
| Error handling |
|
|
| Execution (multiple scripts on multiple databases) |
|
|
| Execution (parallel script on multiple databases) |
2019 |
|
| Execution (possibility of script execution on its own connection) |
2019 |
|
| Execution (selected text in a script) |
2019 |
|
| Execution (serial script on multiple databases) |
|
|
| Export (CSV, TXT) |
|
|
| Export (Excel, XML) |
2019 |
|
| 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) |
2019 |
|
| Pre-execution (combine script lists) |
|
|
| Pre-execution (script lists) |
|
|
| Pre-execution (preview by databases or by scripts) |
|
|
| Multiple violation per rule |
2018 R4 |
|
| Report (XML) |
|
|
| Rule categories |
|
|
| Duplicate code finder for object pairs, objects and script blocks |
2019 |
|
| 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 |
2019 |
|
| Deploy object changes directly from source control label |
|
|
| Error-free synchronization script |
|
|
| Examine differences using the summary view |
2019 |
|
| 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 |
2019 |
|
| Temporal tables support |
2019 |
|
| Transparent decryption of encrypted objects |
|
|
| Visual filtering of schema objects |
|
|
| Filterable difference codes |
|
|
| MySQL schema comparison |
2019 |
|
| Object mapping |
2019 |
|
| 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 |
2019 |
|
| Search across several object types and databases |
|
|
| Search history |
|
|
| Search part of SQL object definition |
2019 |
|
| Search with wildcards and booleans |
|
|
| Toolbar support |
2019 |
|
| 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 |
|
|
| SQL graph support |
2018 R9 |
|
| Team Foundation Server check-in policies |
|
|
| View user changes |
|
|
| Work item association |
|
|
| 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 |
2019 |
|
| 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 |
2019 |
|
| Safe rename |
|
|
| Search for invalid objects |
2019 |
|
| 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 |
2019 |
|
| Between-column dependency support |
2019 |
|
| Create meaningful test data with the predefined generator |
|
|
| Direct execution against database |
|
|
| Generate test data into graph node tables |
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 |
|
|
