ApexSQL DevOps toolkit 2018 R10 has been released
About ApexSQL DevOps toolkit: ApexSQL DevOps toolkit is a set of open source PowerShell cmdlets for automating work flow pipelines to integrate database changes, test and deliver to production. It supports integration with Bamboo, Jenkins, TeamCity, AppVeyor, GoCD, CruiseControl, Hudson, Visual Studio Team Services, Team Foundation Server, and other CI/CD servers. It contains predefined Continuous Integration (CI) and Continuous Delivery (CD) PowerShell script templates for standalone use where all pipeline steps can be customized, reordered, added and removed. It also contains a native TeamCity, a native Atlassian Bamboo, a native Jenkins continuous integration server, a native Azure DevOps Server (TFS) / Azure DevOps Services plugin and a standalone Web dashboard for configuration and execution of CI and CD workflow pipelines via point and click graphical interface.
For more information, visit the ApexSQL DevOps toolkit product page
About this release:
ApexSQL DevOps toolkit – Azure DevOps plugin
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
See also:
Release notes
Download
March 8, 2019