ApexSQL DevOps toolkit - Jenkins plugin release notes

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

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

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