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

ApexSQL DevOps toolkit - Jenkins plugin release notes

Release:

2018.14.0169

Date:

May 17, 2019

Enhancements:

  • Mask sensitive data

Fixes:

  • Compare step is always successful due to incorrect default scope of object types is used in comparison
  • Pre-deployment validation in the Deploy step is always successful due to incorrect default scope of object types is used in comparison
  • Post-deployment validation in the Deploy step is always successful due to incorrect default scope of object types is used in comparison

Release:

2018.12.0161

Date:

March 29, 2019

Enhancements:

  • Provision a database
  • Backup database
  • Compare production database with source control
  • Validate schema changes
  • Format and obfuscate SQL code
  • Include custom PowerShell script

Fixes:

  • “Object MS_Description not found” messages are shown multiple times in the output log when the Document step is reordered and the Changes only option selected
  • “Object already exists” warnings are shown multiple times when the Build step is executed and artifacts from previous execution remained in the checkout folder

Release:

2018.06.0079

Date:

December 04, 2018

Features:

  • Native Jenkins 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