You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Build from source control
Include static data in builds
Generate synthetic test data
Automatically run SQL unit tests
Add a data change audit trail
Document and report on changes
Create a sync script
Plug into popular build servers
Work with all popular SC systems
Trigger manually or automatically

Choose your implementation

PowerShell scripts

A library of Open source PowerShell scripts hosted on GitHub allow for full control over your pipelines. Run the scripts stand alone or integrate with Build servers that support PowerShell/CLI integration like CruiseControl.

Web dashboard

A standalone web dashboard allows for quick set up, configuration and execution of CI/CD workflow pipelines initiated manually, on a schedule or on a commit.

Build server plug-ins

Plug-ins to your favorite build servers like TeamCity and Jenkins that allow you to easily integrate your database pipelines into existing workflows.

SQL Server database continuous integration workflow COMMIT step – Initially committing a SQL database to a source control repository

This article describes the Commit step, in which any new changes are committed to the source control repository and that actually invokes the CI process

SQL Server database continuous integration workflow BUILD step – Building a SQL database from a source control repository

This article describes the Build step, triggered by changes committed to the source control repository, using the latest state of the repository to build a database

SQL Server database continuous integration workflow POPULATE step – Populating the newly built SQL database with data

This article describes the Populate step, in which a created database is populated with static data

SQL Server database continuous integration workflow TEST step – Running SQL unit tests against the changes

This article describes the Test step, where specified unit tests are executed, and the feedback of a success/failure is provided to developers

SQL Server database continuous integration workflow SYNC step – Synchronizing a database with a source control repository

This article describes the Sync step, which will use the tested database to synchronize it with the database in another environment (QA), if all unit tests were successful

SQL Server database continuous integration workflow DOCUMENT step – Creating database documentation

This article describes the Document step, where database documentation is created, using the latest changed database version

ApexSQL Redgate®
Interface
      PowerShell cmdlets
      Web dashboard 2017 R2
Native plugins
      Bamboo 2017 R2
      Jenkins 2017 R2
      TeamCity 2017 R2
      Team Foundation Server / Visual Studio Team Services 2017 R2
PowerShell integration
      Bamboo
      Jenkins
      TeamCity
      AppVeyor
      GoCD
      Hudson CI
      CruiseControl
      Visual Studio Team Services
      Team Foundation Server
      Any other CI server with PowerShell support
      Octopus Deploy 2017 R2
General features
      Check for invalid objects
      Build a database directly from source control
      Include static data in builds
      Generate synthetic test data
      Run SQL unit tests
      Synchronize target database with source control
      Automatically create rollback scripts
      Document and report on changes
      Create deployment package
      Archive all output files in a central folder
      Get notified when changes are detected in source control, before a build starts 2017 R2
      Trigger an automated build on changes in source control 2017 R2
      Audit senstive tables with DML triggers
      Flexible pipeline creation 2017 R2
      Forecast build with a rules-based review 2017 R3
Data sources
      Live database
      Source control
      Script folder 2017 R2
      SQL script file
Trigger
      Manually
      On a schedule
      On changes in source control 2017 R2
Continuous integration steps
      Notify
      Build
      Populate
      Test
      Audit
      Review 2017 R3
Continuous delivery steps
      Notify
      Build
      Sync schema
      Sync data
      Document
      Package
      Deploy
Source control system support
      Git Native Native
      Subversion Native Native
      Team Foundation Server Native Native
      Mercurial Native CLI
      Perforce Native CLI
Other
      Publish NuGet packages 2017 R2
      Documentation of database changes only 2017 R3
      Customizable data sources
      Open sourced PowerShell code downloadable from GitHub
      Support for advanced configuration through individual step project files
Licensing
Free/open source One SQL Toolbelt license per project user

ApexSQL CI/CD toolkit 2017

Redgate® DLM Automation


Comparison was conducted on March 15, 2017

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates

Bamboo TeamCity Jenkins Visual Studio
AppVeyor CI Go Continuous Delivery Cruise Control CI Hudson CI

Why choose us?

Flexible

Choose your implementation from full programmatic control, to an out-of-the-box web dashboard to plug n’ play integration with any popular build server e.g. Jenkins. Our customizable workflow builder supports any pipeline configuration.

Free

Our Continuous integration and delivery toolkit is free and require no additional purchases, other than your existing ApexSQL tools.

Comprehensive

We provide all of the CI and CD workflow pipeline steps you would ever need including Auditing and Review (tba).

Roadmap

Build server plug-ins

Native plug-ins for the most popular build servers to easily integrate database pipelines into existing workflows

Flexible pipeline creation

Add, remove and rearrange pipeline steps

Publish NuGet packages

Create and publish standard NuGet packages to a NuGet feed

See our entire roadmap
ApexSQL CI/CD toolkit  2017 R2 Q3 ApexSQL CI/CD toolkit  2017 R3 Q3
Interface
Build server plug-ins
Web dashboard
Native plugins
Bamboo
Jenkins
TeamCity
Team Foundation Server / Visual Studio Team Services
PowerShell integration
Octopus Deploy
General features
Get notified when changes are detected in source control, before a build starts
Trigger an automated build on changes in source control
Forecast build with a rules-based review
Data sources
Script folder
Continuous integration steps
Review
Other
Flexible pipeline creation
Publish NuGet packages
Documentation of database changes only
ApexSQL CI/CD toolkit  2017 R2 Q3 ApexSQL CI/CD toolkit  2017 R3 Q3

CI-CD workflow pipeline