For the best web experience, please use IE11+, Chrome, Firefox, or Safari

ApexSQL Azure DevOps toolkit - Azure 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