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

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

Enhancements:

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

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