For the best web experience, please use IE11+, Chrome, Firefox, or Safari

ApexSQL DevOps toolkit - Bamboo plugin release notes

Release:

2019.07.0195

Date:

January 24, 2020

Fixes:

  • "java.lang.NullPointerException: Log entry can't be null" error is encountered when executing pipeline with remote agent older than version 6.9.2

Release:

2019.06.0194

Date:

December 13, 2019

Enhancements:

  • Bamboo remote agent support

Release:

2019.01.0181

Date:

June 25, 2019

Enhancements:

  • Provision a database
  • Backup database
  • Compare production database with source control
  • Validate schema changes
  • Format and obfuscate SQL code
  • Sync step can be sourced directly from source control
  • Sync data step can be sourced directly from source control
  • Environmental variable ${bamboo.apexsql.outputPath} is added to use as the current execution output path

Fixes:

  • Static data is included in the package when the Include static data option in the Build step is unchecked

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:

2018.04.0054

Date:

October 11, 2018

Features:

  • Native Atlassian Bamboo 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
  • Automatically create rollback scripts
  • Flexible pipelines