Branch your database in Git for seamless database branch switching
SQL Change Automation integration brings cloning technology into DevOps tooling: select SQL Clone as a development source when creating a new project in SCA
Hybrid workflow: combine elements from both state- and migrations-based approaches to customize your workflow to your needs
New version control tab integrates with Git to let you commit, push and pull changes, all without leaving SSMS
SQL Clone integration:
Set up new projects in seconds using production-like data with the new option in SQL Change Automation to invoke SQL Clone for provisioning development databases
Branch your database in Git as quickly and simply as your code. SQL Clone enables multiple copies of the same database to exist on a single instance and makes switching branches seamless
SQL Prompt 8 includes our brand new formatting engine. You can finely tune your formatting style, save multiple styles, share with others and quickly switch between them.
Support for SQL Server Management Studio 17
Formatting improvements
Azure support:
Visual Studio Azure connection support
Azure active directory universal authentication support
Additional support for Visual Studio 2017
Formatting improvements
SQL Prompt now suggests the MIXED_PAGE_ALLOCATION option
SQL Server 2016 support, with improved support for Always On Availability Groups, including backups from a ReadOnly secondary replica.
Support for Email Encryption in server options. Improved support for removable storage media. Support for multiple DATETIMEs. Support for .NET 4 and .NET 3.5. UI update.
New dashboard. See the current state of your entire environment at a glance. Quickly identify systems that are in trouble. Drill down to find out whats going on. Easily add new servers.
Code suggestions for Azure SQL Data Warehouse & Analytics Platform System (APS - formerly known as Parallel Data Warehouse). Results grid features: Copy as IN clause, Script as INSERT, Open in Excel. Execution warnings for DELETE and UPDATE statements.
Support for profiling ASP.NET 5 applications running on DNX and CoreCLR, Visual Studio 2015, and profiling .NET Cloud Services within the Azure emulator.
Tab coloring. ORDER BY/GROUP BY improvements. Import/export options. SQLCMD mode support. Visual Studio 2015 support. Improvements to Snippets manager.
Active Directory support. Monitoring for AlwaysOn Availability Groups, with dedicated performance metrics and operational alerts. Support for SQL Server 2016. Performance and UI improvements.
Track changes and receive alerts when database schemas are changed in any environment. Get a clear audit history of what's changed. Use pipelines to visualize your database lifecycle. Make sure what you released is still what you're running on your server.
Assign permissions per user or Active Directory group to control who has access to DLM Dashboard, and which actions they can perform.
Git support and working folder to allow arbitrary source control systems. Performance improvements too numerous to mention. Advanced search to quickly refine your commit. Granular settings when committing storage options to source control.
Build and test your database on every commit. Synchronize a database to match the state in version control. Command line tools for any CI server. Plugins for TeamCity, TFS, and MSBuild.
Deep integrated database profiling: see execution plans for SQL Server queries and stored procedures, as well as how they relate back to your .NET code.
Data compare between views. Up to 100x speed improvement comparing date time columns. Option to include column names for inserts. LDAP lookup and authentication.
Object level filtering can now be configured and committed to source control. CREATE OR REPLACE scripting. UI performance improvements. Speed improvements. Improved Materialized View support. LDAP lookup and authentication. TFS2013 client and server support.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data