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