OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

Products

Redgate roadmap

Upcoming releases

  1. SQL Data Catalog

    • 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

  2. SQL Monitor

    • Improved instance-level support for Azure Managed Instances.
    • Improved reporting functionality.
    • Custom tagging for improved server management.
    • Full SQL Monitor roadmap

  3. SQL Compare

  4. SQL Prompt

    • Support for SQL Server 2019
    • Prioritized suggestions
    • Improvements to code analysis and autofixes
    • Full SQL Prompt roadmap

  1. SQL Change Automation

    • Support for building and baselining of "complex" databases
    • DevOps dashboard to visualize frequency and other metrics on database deployments

  2. SQL Doc

    • Support for markdown generation

  3. SQL Provision

    • Data Masker

    • SQL Clone

      • 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

  4. ANTS Performance Profiler

    • Support for markdown generation

2020

  1. SQL Monitor 11.0

    • Support for Amazon RDS.
    • Dedicated metrics for monitoring tempdb.
    • Information on user processes.
    • Performance improvements.

  2. SQL Monitor 10.1

    • 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.

  3. SQL Monitor 10.0

    • 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

  1. SQL Clone 4.4

    • 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

  2. SQL Change Automation 4.3

    • Added Graphical Interface for SQL Clone-as-baseline functionality

  3. SQL Change Automation 4.2

    • 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

  1. SQL Monitor 9.2

    • Support for .NET Framework 4.7.2

  2. SQL Monitor 9.1

    • New API functionality
    • Server permission information

  3. SQL Monitor 9.0

    • Full support for Azure SQL Databases
    • New Estate management section

  1. SQL Prompt

    • Support for SQL Server Management Studio 18 and Visual Studio 2019
    • Database connection management for suggestions

2018

  1. SQL Monitor

    • 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

  2. SQL Prompt

    • 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

  3. SQL Clone

    • 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

  4. SQL Source Control

    • Pre/Post deployment scripts
    • Improved GIT support
    • SSMS 2018 support

  1. SQL Compare

    • 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

  2. SQL Change Automation

    • Static code analysis

  3. ANTS Memory Profiler

    • Profile .NET Core applications

  4. .NET Reflector

    • Decompile C#7 and .NET Core assemblies

2017

  1. SQL Prompt

    • 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 MIXED_PAGE_ALLOCATION option
    • Improvements to AT TIME ZONE suggestions

  1. SQL Compare

    • 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

  2. SQL Clone 2

    • 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

1058 releases

  1. SQL Compare & SQL Data Compare

    • 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.

  2. SQL Source Control

    • 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.

  3. DLM Automation

    • SQL CI and SQL Release merged into one product, with enhanced PowerShell capabilities allowing customized deployment workflows.

  4. SQL Backup Pro 8

    • 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.

  5. ANTS Performance Profiler

    • Performance improvements to analysis views.

  6. SQL Test

    • UI now appears in a tab window in SQL Server Management Studio. SQL Server 2016 support.

  7. SQL Data Generator

    • IDENTITY columns can now be populated from a source table or with default values, to help with data masking.

  8. SQL Dependency Tracker, SQL Doc, SQL Multi Script

    • Updated UI. Switch between products easily, taking context with you, when used as part of the SQL Toolbelt. SQL Multi Script now saves projects.

  1. SQL Monitor 6

    • 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.

  2. SQL Monitor 5.2

    • 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.

  3. SQL Monitor 5.1

    • 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)

  4. SQL Prompt

    • 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.
    • Full release notes

2015

722 releases

  1. ANTS Performance Profiler & ANTS Memory Profiler

    • Support for profiling ASP.NET 5 applications running on DNX and CoreCLR, Visual Studio 2015, and profiling .NET Cloud Services within the Azure emulator.

  2. SQL Source Control 4

    • Improvements to Git integration. UI improvements for easier configuration. Object locking from within SSMS. Bug fixes.
    • For regular releases join our
      Frequent Updates channel.

  3. SQL Release

    • Safe, automated production deployments for databases. Provides update scripts, change reports, & review steps.

  4. SQL Prompt 7

    • Tab coloring. ORDER BY/GROUP BY improvements. Import/export options. SQLCMD mode support. Visual Studio 2015 support. Improvements to Snippets manager.

  5. SQL Monitor 5

    • Active Directory support. Monitoring for AlwaysOn Availability Groups, with dedicated performance metrics and operational alerts. Support for SQL Server 2016. Performance and UI improvements.

  6. SQL Doc, SQL Data Generator, SQL Dependency Tracker, SQL Test, & SQL Index Manager

    • Support for SQL Server 2016, bug fixes

  7. DLM Automation

    • Richer integration with DLM Dashboard and more accessible documentation artifacts.

  1. Data Compare for Oracle

  2. Source Control for Oracle

    • 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.

  3. Schema Compare for Oracle

    • Granular settings for comparing and deploying storage options. Bug fixes and continuing gradual support for 12c.

  4. .NET Reflector

    • Support for C#6 and Visual Studio 2015 integration.

2014

834 releases

  1. SQL Compare & SQL Data Compare 11

    • Full SQL Server 2014 support, including comparison and deployment of memory-optimized table types

  2. SQL Server 2014 support

    • SQL Source Control v3.6.0.3
    • SQL Prompt v6.2.0.241
    • 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

  3. SQL Doc 3

    • 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

  4. SQL Data Generator 3

    • Support for cross-column dependencies
    • More realistic test data
    • Improved foreign key support

  5. 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.

  6. SQL Prompt 6.4

    • Inserting semicolons, easily executing current statements, renaming variables and aliases.

  1. SQL Search 2

    • Support for larger databases and result sets
    • More flexible and customizable searching
    • Performance improvements

  1. SQL Monitor 4

    • Performance diagnostics, including detailed wait stat analysis

  1. ANTS Performance Profiler 9

    • 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.

  2. .NET Reflector 8.44

    • Support for the Visual Studio 2014 CTP

  1. Schema Compare for Oracle

    • 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.

  2. Data Compare for Oracle

    • Data compare between views. Up to 100x speed improvement comparing date time columns. Option to include column names for inserts. LDAP lookup and authentication.

  3. Source Control for Oracle

    • 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

565 releases

  1. SQL Doc 3

    • SQL Server 2012 support
    • Greater level of documentation customization

  2. SQL Source Control 3.5

    • Support for multiple SSMS instances
    • Merge conflicted stored procedures

  3. SQL Prompt 6

    • Tab History in SSMS
    • SQL Azure and Win8 support
    • Improved snippets with more placeholders
    • Support for synonyms, CLR, and XML

  4. SQL Automation Pack

    • Use Redgate tools for continuous integration on a build server

  5. SQL Source Control 3

    • Support for every source control system

  6. SQL Packager 7

    • SQL Server 2012 support

  1. SQL Backup Pro 7

    • Cloud storage for database backups

  2. SQL Monitor 3

    • Better time control navigation, email alert improvements, multiple metrics analysis, automatic baselines

  1. ANTS Performance Profiler 8

    • Performance data for outgoing web requests
    • Async and WinRT support
    • Enhanced database profiling support (profile MySQL and PostgreSQL)

  2. ANTS Memory Profiler 8

    • Profile unmanaged memory

  3. SmartAssembly 6

    • Support for portable class libraries, very large assemblies, and further improvements for WPF

  1. Source Control for Oracle 1 & 2

    • Connect Oracle schemas to Subversion or Team Foundation Server
    • Lock objects on shared development databases

2012

525 releases

  1. SQL Compare 10

    • 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

  2. SQL Data Compare 10

    • SQL Server 2012 support
    • Select a previous version of the database with static data from source control
    • Remembers recently used servers

  3. SQL Comparison SDK 10

    • SQL Server 2012 support

  4. SQL Source Control 3

    • SQL Server 2012 support and performance enhancements

  5. SQL Connect

    • Database source control inside Visual Studio

  6. SQL Test

    • Unit testing inside SQL Server Management Studio

  1. SQL Backup Pro 7

    • Scheduled restores
    • Integrated DBCC CHECKDB

  2. SQL Monitor 3

  1. ANTS Performance Profiler 7

    • SharePoint 2010 and IIS Express support
    • Integrated decompilation
    • Database call profiling
    • HTTP request grouping

  2. ANTS Memory Profiler 7

    • SharePoint 2010 and IIS Express support

  3. SmartAssembly 6

    • Method parent obfuscation, Silverlight 5 support, better WPF obfuscation

  1. Schema Compare for Oracle 2 & 3

    • Command line version for continuous integration
    • Export, compare, and sync databases with a scripts folder

  2. Data Compare for Oracle 2

    • Command line version
    • Improved comparison options

2011

141 releases

  1. SQL Source Control 3,
    SQL Compare 10

    • Migration scripts for custom deployments

  2. SQL Source Control 2

    • Source control for static data
    • Support for Mercurial, Perforce, and Git

  3. SQL Compare 9,
    SQL Data Compare 9

    • Support for SQL Azure databases

  4. SQL Data Generator 2,
    SQL Doc 2,
    SQL Dependency Tracker 2

    • Integration into SQL Server Management Studio

  1. SQL Backup Pro 6

    • Numerous UI improvements

  2. SQL Monitor 2

    • Maintenance windows
    • New alerts
    • Top 10 most expensive queries

  1. ANTS Memory Profiler 7

    • Instance categorizer graph
    • A new API
    • Improved WPF support

  2. SmartAssembly 6

    • Feature usage tracking and Windows Phone 7 error reporting

2010

99 releases

  1. SQL Prompt 5

    • Find invalid objects
    • View column dependencies
    • Smart renaming

  2. SQL Source Control

    • Database source control in SQL Server Management Studio, using your existing version control system

  3. SQL Search

    • Search inside SQL Server database schemas

  1. SQL Monitor 2

    • Web-based performance monitoring and alerting

  1. ANTS Memory Profiler 6

    • .NET 4 and Silverlight support

  1. Schema Compare for Oracle,
    Data Compare for Oracle

    • Compare and deploy Oracle schemas and data