What’s new in the ApexSQL DevOps toolkit – Bamboo build server plug-in


Bamboo is a “Build server” from Atlassian for continuous integration, continuous delivery and deployment, from a variety of technologies. It will provide the DevOps teams necessary means to build and deploy projects. More information on this tool can be found here

The ApexSQL DevOps toolkit is a set of components and scripts that integrate with the CLI of our SQL developer tools, providing one of the solutions for constructing DevOps toolchains to build sophisticated and powerful continuous integration and continuous delivery pipelines right out of the box.

Bamboo plug-in

With a native plug-in for Bamboo included in the ApexSQL DevOps toolkit, ApexSQL adds our organic SQL Server continuous integration and delivery capabilities as well. With the plug-in present on Bamboo continuous integration server, DevOps users can use steps from variety of choices packed in one plug-in to create automated CICD pipelines.


Our Bamboo plug-in will include the following steps

  • Build
  • Populate
  • Audit
  • Test
  • Review
  • Document
  • Package
  • Publish
  • Schema sync
  • Data sync
  • Deploy

  1. Build step

Build your database from a source control repository. Also, you will be able to include/exclude static data from chosen data source.

  1. Populate step

Populate all empty tables (not populated with Static data from the Build step) with randomly generated test data

  1. Audit step

Audit sensitive tables with DML triggers

  1. Test step

Automatically run unit tests, including SQL Cop, on your database and determine a Pass/Fail status

  1. Review step

Run custom rulebase against SQL objects to enforce best practices

  1. Document step

Fully document the newly created database or just the changes from the current build

  1. Package step

Create a NuGet package and store outputs from others step in it.

  1. Publish step

Publish a current or specific NuGet package to your feed providing the URL and API key.

  1. Sync step

Create a script to synchronize the latest build with a target database. Produce a report of all schema changes

  1. Sync data step

Create a script to synchronize the latest build with a target database, for any static data changes. Produce a report of all data changes

  1. Deploy step

Execute synchronization scripts from a current or specific NuGet package against a specific Target database e.g. Production


October 11, 2018