Redgate roadmap Upcoming releases Improved prioritizing and tracking Easier classification with improved filters and overviews Improved reporting Better automation with improved documentation and examples Full SQL Data Catalog roadmap Improved instance-level support for Amazon RDS Improved integrations support via webhooks Dedicated metrics for monitoring TempDBs Full SQL Monitor roadmap Support for SQL Server 2019 Prioritized suggestions Improvements to code analysis and autofixes Full SQL Prompt roadmap Support for building and baselining of "complex" databases DevOps dashboard to visualize frequency and other metrics on database deployments Full SQL Change Automation roadmap Support for markdown generation Support for Oracle (and other relational database management systems) Provisioning of complex environments for Development, Test and CI workflows (including support for containerized development) Full SQL Clone roadmap Support for markdown generation 2020 Increased IT Service Management (ITSM) systems support via webhooks, including Microsoft Teams and Splunk. Estate-wide SQL Server licensing information. Improved support for complex Active Directory environments. Alert suppression management Support for IT Service Management (ITSM) systems Annotate server overview graph Improved performance metrics Alert summary report New support menus Support for WinRM New alerts for auditing and Clustered Shared Volumes Ability to filter and ignore objects as part of a migrations-based release process A simpler cmdline for setting up build, test, and release as part of CI/CD processes for hybrid and migrations-based approaches A hybrid model to use state for development and migrations for deployments An updated, more readable code analysis report An updated more readable change report to easily understand how each object will be changed during a release 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 Image compaction 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 2019 Support for .NET Framework 4.7.2 New API functionality Server permission information Full support for Azure SQL Databases New Estate management section Support for SQL Server Management Studio 18 and Visual Studio 2019 Database connection management for suggestions Automate your build and release process on Linux Support for migrations-based deployments to have more control over releases Static PL/SQL code analysis to ensure best practices are being followed 2018 Distributed monitoring Grouped alert inbox Deadlock visualizations Query history graph Blocking processes information and visualization Deployment integration with Redgate tools: SQL Change Automation Database file growth alerts Bulk server import and import API Linux support for the command lines Support for migrations-based deployments Pre-filtering in Schema Compare for Oracle and Source Control for Oracle Export and share code analysis setting throughout a team Search bar for snippets List of issues window for code analysis. Including the ability to go directly to issues and sort them by groups. Refactor INSERT statements to UPDATE statements After reformatting, actions that were successfully executed and those that were skipped are now displayed along with the failures. Auto fixes for code analysis New dashboard to boost manageability and visibility of clones and images Search and order functionality Activity view with download logs Ability to reset clones from the dashboard Images can be renamed from the dashboard Added PowerShell support for running T-SQL scripts on clone creation Pre/Post deployment scripts Improved GIT support SSMS 2018 support Improved temporal tables support Azure Active Directory authentication Summary view of detailed differences Last modified dates: see when each object in the comparison results grid was last modified Toggle automatic mapping of similar columns Improved update notifications with new banner Ignore objects known to be irrelevant to improve performance Added ability to deploy static data held in source control The project refresh mechanism has been optimized Extended NESTED TABLES comparison Support .NET 4.6.1 framework Improved "Tables & Views" tab dialog, with support to map tables of different names Show differences to the sco.exe command line tool console output in verbose mode. Static data deployment in Data Compare for Oracle Profile .NET Core applications Decompile C#7 and .NET Core assemblies 2017 New code analysis New INSERTS formatting options New parenthesis formatting options 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
AT TIME ZONE suggestions
Improved temporal tables support Azure Active Directory authentication Summary view of detailed differences Last modified dates: see when each object in the comparison results grid was last modified Toggle automatic mapping of similar columns Improved update notifications with new banner Support for comparison and deployment of temporal tables in SQL Server 2016 Option to ignore performance indexes and select a Git revision as a data source SQL script runner and UI improvements Improvements to SQL Clone 2 agent management and support for filestream Released version 2 which includes support for cloning up to 64TB databases and enhanced role based access permissions 2016
New UI to enhance usability. New migrations support, compatible with SQL Source Control 5. Initial support for SQL Server 2016 and Azure SQL Database V12. Support for TFS 2015 and Subversion 1.9. Improved performance when detecting changes to stored procedures, tables, and indexes. SQL Server 2016, SSMS 2016 support. Improvements to migrations – read more. DLM Automation SQL CI and SQL Release merged into one product, with enhanced PowerShell capabilities allowing customized deployment workflows. 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.
Performance improvements to analysis views. UI now appears in a tab window in SQL Server Management Studio. SQL Server 2016 support.
IDENTITY columns can now be populated from a source table or with default values, to help with data masking.
Updated UI. Switch between products easily, taking context with you, when used as part of the SQL Toolbelt. SQL Multi Script now saves projects. Server and instance overview redesign. New diagnostic interface to quickly determine root causes of performance issues. Find out when a problem started, what went wrong, and what led to things going wrong, even after the fact. View query execution plan for top queries. 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. Windows Server 2016 support. Significant performance improvements so you can reliably monitor 100s of servers from a single installation More actionable operational alerts with improved behavior to eliminate false positives Azure and Amazon EC2 support (IaaS) 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
Full release notes Hide unused categories from the Pipeline view and rename categories 2015
Support for profiling ASP.NET 5 applications running on DNX and CoreCLR, Visual Studio 2015, and profiling .NET Cloud Services within the Azure emulator. Improvements to Git integration. UI improvements for easier configuration. Object locking from within SSMS. Bug fixes. For regular releases join our Frequent Updates channel. SQL Release Safe, automated production deployments for databases. Provides update scripts, change reports, & review steps. Tab coloring.
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. Support for SQL Server 2016, bug fixes DLM Automation Richer integration with DLM Dashboard and more accessible documentation artifacts. 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. Granular settings for comparing and deploying storage options. Bug fixes and continuing gradual support for 12c. Support for C#6 and Visual Studio 2015 integration. 2014
Full SQL Server 2014 support, including comparison and deployment of memory-optimized table types SQL Server 2014 support SQL Source Control v126.96.36.199 SQL Prompt v188.8.131.52 SQL Dependency Tracker v2.8 SQL Backup v7.7 SQL Monitor v4.1 SQL Search v2 SQL Multi Script v1.1 SQL Test v1.5 SQL Comparison SDK v11 New HTML formatting options for greater customization New UI with better navigation Include or exclude any section of any object from documentation Support for SQL Server 2014 & Windows Azure SQL Database Support for cross-column dependencies More realistic test data Improved foreign key support SQL CI 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. Inserting semicolons, easily executing current statements, renaming variables and aliases. Support for larger databases and result sets More flexible and customizable searching Performance improvements Performance diagnostics, including detailed wait stat analysis 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. Support for the Visual Studio 2014 CTP Automatic rename column detection. Better command line support for CI. Ignore external table location. CREATE OR REPLACE scripting. Speed improvements. Improved Materialized View support. LDAP lookup and authentication. 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. 2013
SQL Server 2012 support Greater level of documentation customization Support for multiple SSMS instances Merge conflicted stored procedures Tab History in SSMS SQL Azure and Win8 support Improved snippets with more placeholders Support for synonyms, CLR, and XML SQL Automation Pack Use Redgate tools for continuous integration on a build server Support for every source control system SQL Packager 7 Cloud storage for database backups Better time control navigation, email alert improvements, multiple metrics analysis, automatic baselines Performance data for outgoing web requests Async and WinRT support Enhanced database profiling support (profile MySQL and PostgreSQL) Support for portable class libraries, very large assemblies, and further improvements for WPF Connect Oracle schemas to Subversion or Team Foundation Server Lock objects on shared development databases 2012
SQL Server 2012 support Rerunnable scripts – add object existence checks and recreate objects Remembers recently used servers Table mapping Create new databases straight from SQL Compare Specify transaction isolation level to work with linked servers SQL Server 2012 support Select a previous version of the database with static data from source control Remembers recently used servers SQL Server 2012 support and performance enhancements SQL Connect Database source control inside Visual Studio Unit testing inside SQL Server Management Studio Scheduled restores Integrated
SharePoint 2010 and IIS Express support Integrated decompilation Database call profiling HTTP request grouping SharePoint 2010 and IIS Express support Method parent obfuscation, Silverlight 5 support, better WPF obfuscation .NET Demon Build-as-you-type extension for Visual Studio Command line version for continuous integration Export, compare, and sync databases with a scripts folder Command line version Improved comparison options 2011
Migration scripts for custom deployments Source control for static data Support for Mercurial, Perforce, and Git Support for SQL Azure databases Integration into SQL Server Management Studio Maintenance windows New alerts Top 10 most expensive queries Instance categorizer graph A new API Improved WPF support Feature usage tracking and Windows Phone 7 error reporting 2010
Find invalid objects View column dependencies Smart renaming Database source control in SQL Server Management Studio, using your existing version control system Search inside SQL Server database schemas Web-based performance monitoring and alerting .NET 4 and Silverlight support Compare and deploy Oracle schemas and data Copyright 1999 - 2020 Red Gate Software Ltd