ApexSQL CI/CD Toolkit 2018 Released

Chapel Hill, NC, August 22, 2018 --(PR.com)-- ApexSQL, a Microsoft Gold Certified Partner and major provider of Microsoft SQL Server solutions, announced the new product release - ApexSQL Job 2018.

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.

For more information, visit the ApexSQL CI/CD toolkit product page.

About this release:

ApexSQL CI/CD toolkit TeamCity plugin

Features:
- 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

See also: ApexSQL CI/CD toolkit 2018 release notes