ApexSQL CI/CD toolkit 2018 R2 – Product update alert

ApexSQL CI/CD toolkit 2018 R2 has been released

About ApexSQL CI/CD toolkit: ApexSQL CI/CD 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 continuous integration server 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 CI/CD toolkit product page

About this release:

ApexSQL CI/CD toolkit Web dashboard


  • Standalone graphical web user interface
  • 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
  • Fill empty tables with synthetic data
  • Support for multiple data source types
    • SQL Server database
    • Source control (Git, Mercurial, Perforce, Team Foundation Server, Subversion)
    • SQL script
    • Script folder
    • NuGet package (local or feed)
  • Automatically create rollback scripts
  • Flexible pipelines
  • Predefined user roles
  • Per user CI/CD pipeline access
  • GUI themes

See also:
Release notes


June 12, 2018