As an new addition to the plug-in family of the ApexSQL DevOps toolkit, a database continuous integration and continuous delivery solution, we are announcing Azure DevOps plugin. This plugin will integrate easy-to-use database CI and CD automation workflow designer to Azure DevOps project environment and expand it with database build, testing and deployment capabilities.
Based on user design, automated pipelines will trigger execution of SQL developer tools through CLI with parameters customized through Azure DevOps native user interface.
A workflow can be designed through set of ApexSQL DevOps toolkit steps available immediately upon plugin installation by adding and configuring them in standard Azure DevOps pipeline job configurations. The steps can be used as separate database projects or added in pipelines along other tasks related to some existing projects of different nature.
Available pipeline steps are:
Build a QA/Staging database directly from source control repository to a SQL Server with or without static data. Validate changes by checking object dependencies and test database buildability.
Perform data population test with synthetic data on newly added empty tables.
Implement auditing triggers on-the-fly on new tables sensitive to changes. Optionally add auditing architecture if there is no existing one.
Install tSQLt framework and perform SQL unit tests using built-in SQLCop tests or by importing custom made test classes.
Perform custom rulebase checkup to enforce database best practices. Use it as SQL code quality auto-approval method or to review found issues through detailed reports.
Create full database documentation or document delta between two database versions for easy review of changes.
Prepare NuGet deployment package containing database script folder with or without static data included and cleared of synthetic tests data.
prepare schema synchronization script by comparing database script folder stored in a deployment package with a target/production database.
Prepare data synchronization script by comparing database script folder stored in a deployment package with a target/production database.
Execute schema and data synchronization scripts to update target database.
Push created NuGet deployment package to an online feed with all summaries and reports included
For more detailed information on how to install and use this plugin see: