You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
 

ApexSQL Azure DevOps toolkit - Azure DevOps Server (TFS) / Azure DevOps Services plugin release notes

Release:

2019.05.0193

Date:

November 22, 2019

Enhancements:

  • ApexSQL steps now use dedicated folder to store output artifacts
  • Release pipeline with ApexSQL steps can be sourced with build artifact created from a build pipeline with ApexSQL steps
  • The Sync step can be sourced directly from source control
  • The Sync data step can be sourced directly from source control

Fixes:

  • Missing output files in steps when the Include output in package option is not checked
  • SQL Server username and password are not used in the Audit or Build steps execution when project file is used
  • “Project file requires *.axds" extension" error is encountered when the Sync step is used in release pipeline and no project file is used
  • Synchronization script is not generated when using the Sync step in release pipeline and direct path to a NuGet package is provided as source
  • Additional parameters are not working when used with the Sync step in release pipeline

Changes:

  • Control to change the source for the Sync step is now a select box
  • Control to change the source for the Sync data step is now a select box

Release:

2019.03.0188

Date:

September 20, 2019

Enhancements:

  • Provision a database
  • Backup database
  • Compare production database with source control
  • Validate schema changes
  • Mask sensitive data
  • Format and obfuscate SQL code

Release:

2018.10.0146

Date:

March 08, 2019

Features:

  • Native Azure DevOps Server (TFS) / Azure DevOps Services plugin
  • Support for Team Foundation Server (TFS) 2015, TFS 2017, TFS 2018, Azure DevOps Server 2019 RC2, Azure DevOps Services
  • Continuous integration:
    • Build a SQL Server database directly from source control and optionally include static data
    • Fill empty tables with synthetic data
    • Integrate trigger-based audit trails and reporting into change sensitive database objects
    • Generate full or differential documentation for the SQL Server database
    • Test SQL Server database using unit tests
    • Enforce database best practices by reviewing, detecting and fixing issues
    • Create a clean database package for easy deployment
    • Publish package to a designated NuGet feed
  • Continuous delivery:
    • Compare SQL Server database schemas and create a script for schema synchronization
    • Compare SQL Server static data and create a script for data synchronization
    • Push schema and data changes to a target database
  • Archive all output files in a central folder
  • Automatically create rollback scripts
  • Flexible pipelines

© 2021 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy