| Azure SQL Database (most tools) |
|
|
| SQL Server on Amazon RDS (most tools) |
|
|
| SQL Server Standard and SQL Server Enterprise |
|
|
| SQL Server Express (most tools) |
|
|
| Source control |
|
|
| SQL Server Management Studio (SSMS) |
|
|
| Visual Studio |
|
|
| ApexSQL (proprietary) schema snapshot |
|
|
| Live database |
|
|
| Native backup |
|
|
| Script folder |
|
|
| Source control project |
|
|
| Source control label |
|
|
| 3rd party backup |
|
|
| Database installer, package (e.g. Executable installer, C# solution) |
|
|
| Script folder |
|
|
| Source control project |
|
|
| SQL script |
|
|
| Source control label |
|
|
| Command line interface |
|
|
| Projects |
|
|
| Save as batch |
|
|
| Supporting all popular systems natively vs CLI |
|
|
| Working with source control labels |
|
|
| Working with static data |
|
|
| Git |
Native |
Native |
| Subversion |
Native |
Native |
| Team Foundation Server |
Native |
Native |
| Mercurial |
Native |
CLI |
| Perforce |
Native |
CLI |
| Working with Git branches |
|
|
| Database deployment directly from source control |
|
|
| Multiple script consolidation |
|
|
| Script refactoring (for proper execution order) |
|
|
| Archive all output files in a central folder |
|
|
| Automatically create rollback scripts |
|
|
| Build a database directly from source control |
|
|
| Build server PowerShell integration |
|
|
| Check for invalid objects |
|
|
| Create deployment package |
|
|
| Generate synthetic test data |
|
|
| Get notified when changes are detected in source control, before a build starts |
2018 R2 |
|
| Include static data in builds |
|
|
| Native plugin (TeamCity) |
2018 R1 |
|
| Native plugins (Bamboo, Jenkins, TFS/VSTS) |
2018 R3 |
|
| PowerShell cmdlets |
|
|
| Publish NuGet packages |
2018 R2 |
|
| Report on changes |
|
|
| Run SQL unit tests |
|
|
| Synchronize target database with source control |
|
|
| Trigger an automated build on changes in source control |
2018 R2 |
|
| Audit sensitive tables with DML triggers |
|
|
| Customizable data sources |
|
|
| Documentation of database changes only |
|
|
| Flexible pipeline creation |
|
|
| Review database based on built-in and custom written rules |
|
|
| Web dashboard |
2018 R2 |
|
| Custom comparison key |
|
|
| Data compare filters |
|
|
| Export (CSV) |
|
|
| Impact analysis e.g. warnings and messages |
|
|
| Object mapping |
|
|
| Schema mapping |
|
|
| Source control integration |
|
|
| Pre and post synchronization scripts |
|
|
| Report (Excel) |
|
|
| Reports (HTML) |
|
|
| Database design |
|
|
| Diagramming |
|
|
| Export diagrams (JPEG, PNG, BMP) |
|
|
| Forward engineering |
|
|
| Logical data model |
|
|
| Model comparison |
|
|
| Model conversion |
|
|
| Model synchronization |
|
|
| Physical data model |
|
|
| Reports |
|
|
| Reverse engineering |
|
|
| Visualization |
|
|
| Dependency diagrams customization |
|
|
| Export dependency diagrams |
|
|
| Graphical dependency analysis |
|
|
| Database objects |
|
|
| Dependency documentation |
|
|
| Extended property editor |
|
|
| Server objects |
|
|
| CHM output |
|
|
| HTML output |
|
|
| PDF output |
|
|
| Word (DOCX) output |
|
|
| Analysis services (SSAS) documentation |
|
|
| Custom descriptions via extended properties |
|
|
| Data model diagrams |
|
|
| Database schema snapshot documentation |
|
|
| Documentation styles |
|
|
| Graphical dependencies |
|
|
| Integration services (SSIS) documentation |
|
|
| Reporting services (SSRS) documentation |
|
|
| SharePoint server documentation |
|
|
| SQL Server level information |
2018 R2 |
|
| SQL Server level properties snapshot documentation |
2018 R2 |
|
| Tableau server documentation |
|
|
| Decryption scripts |
|
|
| Object decryption |
|
|
| Code structure viewer |
|
|
| Copy query result as |
|
|
| Execution alerts |
|
|
| Export result grid data to Excel |
|
|
| Locating objects |
|
|
| Object definition |
|
|
| Object description |
|
|
| Snippets |
|
|
| SQL code auto-completion |
|
|
| Tab coloring |
|
|
| Tab navigation |
|
|
| Tooltips |
|
|
| Automatic tab renaming |
|
|
| CRUD procedures |
|
|
| Executed queries |
|
|
| Go to object |
|
|
| Results search |
|
|
| SQL code auto-replacements |
|
|
| Test mode |
|
|
| Block-by-block compare |
|
|
| Char-by-char compare |
|
|
| File compare |
|
|
| Folder compare |
|
|
| HTML report |
|
|
|
| Ignore script options |
|
|
| Line-by-line compare |
|
|
| SQL Server object compare |
|
|
| Syntax highlighting |
|
|
| Two-way comparison and merge |
|
|
| Filterable difference types |
|
|
| Schema mapping |
|
|
| Source control integration |
|
|
| Export (XML) |
|
|
| Report (Excel) |
|
|
| Reports (HTML) |
|
|
| Create snapshot or rollback script prior to synchronization |
|
|
| Create script folder backup prior to synchronization |
|
|
| Export comparison results (SQL and database) |
|
|
| Integration services (SSIS) package comparison |
|
|
| Pre and post synchronization scripts |
|
|
| Data scripting |
|
|
| Permissions scripting |
|
|
| Schema mapping |
|
|
| Schema scripting |
|
|
| Source control integration |
|
|
| Object search |
|
|
| Extended properties editor |
|
|
| Graphical dependency analysis |
|
|
| Safe renaming of objects |
|
|
| Text search |
|
|
| Branching / merging |
|
|
| Change logging |
|
|
| Comparison and synchronization options |
|
|
| Dedicated development model |
|
|
| Local folder |
|
|
| Migration scripts |
|
|
| Object filtering |
|
|
| Object locking |
|
|
| Revision history and change rollback |
|
|
| Shared development model |
|
|
| Static data |
|
|
| Built-in difference merging |
|
|
| Checking out an object |
|
|
| Labels |
|
|
| Object status |
|
|
| Policies |
|
|
| Supporting all popular systems natively vs CLI |
|
|
| Find unused variables and parameters |
|
|
| Object name qualifying |
|
|
| Safe renaming of objects |
|
|
| Split table |
|
|
| Wildcard replacement |
|
|
| Add surrogate key |
|
|
| Batch refactoring (expand wildcards, qualify object names) |
|
|
| Change parameters |
|
|
| Copy SQL code to client code e.g. C# |
|
|
| Encapsulate SQL code as e.g. Procedure, Function etc |
|
|
| Replace one-to-many-relationship |
|
|
| Pre-defined formatting profiles e.g. SQL Server Books Online |
|
|
| Batch formatting |
|
|
| Impact preview |
|
|
| Obfuscation |
|
|
| Report (XML) |
|
|
| Unit test creation |
|
|
| Unit test execution |
|
|
| Constraints recognition (check, unique, relationships…) |
|
|
| Cross-column generator with built-in functions |
|
|
| Incremental generator |
|
|
| Manual Foreign key generator |
|
|
| Predefined generators |
|
|
| Regular expression generator with predefined snippets |
|
|
| Table mapping (from SQL table/view or CSV file) |
|
|
| Test data generation by time |
|
|
| Weighted lists (custom or from file) |
|
|
| Dependency viewer |
|
|
| Exports (XML, SQL, CSV, JSON and Excel) |
|
|
| "Filler" text generators (Lorem ipsum, text shuffler, and sentence generator) |
|
|
| Include/exclude dependent tables |
|
|
| User-defined generators |
|
|
| DDL auditing |
|
|
| Email alert upon changes |
|
|
| Audited data management |
|
|
| Auditing customization |
|
|
| Auditing reports |
|
|
| Auditing reports customization |
|
|
| Auditing triggers management |
|
|
| Centralized auditing model |
|
|
