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 data sync script
Create a schema sync script
Plug into popular build servers
Enforce SQL coding standards
Work with all popular SC systems
Trigger manually or automatically

Features

Open source PowerShell cmdlets

Run the toolkit from the CLI with a full, opensource library of cmdlets PowerShell. Modify and change pipelines yourself. Download and update our GitHub hosted library with changes and improvements

See next feature

Web dashboard

The database DevOps tool to create and run CI/CD pipelines via point and click

See next feature

Pipeline customization

Add, edit or remove steps to customize CI and CD pipelines. Change the order of steps. Disable and enable steps in a pipeline without removing them. Applies to PowerShell, Web dashboard and build server Plug-ins

See next feature

Project support

Consume projects to provide powerful step customization capabilities and ensure that steps run the same via the DevOps toolkit as they do when running ApexSQL tools directly. Applies to PowerShell, Web dashboard and build server Plug-ins

See next feature

Additional parameters

Add full CLI configuration, to add additional settings or override settings that exist in the project file. Applies to PowerShell, Web dashboard and build server Plug-ins

See next feature

Saved data sources

Configure and save data sources including databases, source control, script folders, SQL script and Nuget packages, to be consumed by various steps in your pipeline. Make a change to a data source and have it automatically utilized in all steps that use it. Browse saved data sources via the dashboard console. Applies to PowerShell, Web dashboard and build server Plug-ins

See next feature

Notifications

Configure email notifications for any and all events including a pipeline starting and ending as well as individual steps starting, finishing, failing and/or succeeding. Build notifications with a convenient user interface. Applies to PowerShell, Web dashboard and build server Plug-ins

See next feature

Activity view

View all recently run pipelines by name, last run date and status. Applies to the Web dashboard only

See next feature

User management

Create and save users profiles by permission level e.g. Administrator. Manage and edit user profiles directly via a centralized location e.g. Web dashboard page. Applies to PowerShell, Web dashboard and build server Plug-ins

See next feature

Pipeline triggers

Set pipelines to commit on a schedule, manually or on a new commit. Applies to PowerShell, Web dashboard and build server Plug-ins

See next feature

TeamCity build server plug-in

Fully integrate the ApexSQL DevOps toolkit into TeamCity build server. Create CI/CD pipelines using ApexSQL tools running by within the TeamCity build agent.

See next feature

Azure DevOps Server build server plug-in

Integrate directly with Azure DevOps Server via an ApexSQL DevOps toolkit plug-in or integrate via PowerShell.

See next feature

Jenkins build server plug-in

Integrate directly with Jenkins via an ApexSQL DevOps toolkit plug-in or integrate via PowerShell. Learn more

See next feature

Bamboo build server plug-in

Integrate directly with Bamboo via an ApexSQL DevOps toolkit plug-in or integrate via PowerShell

See next feature

Themes

Choose between dark and light colored layouts

See next feature

Custom step

Execute custom PowerShell scripts during database pipeline execution

See next feature

Validate

Check for unexpected target schema changes pre deployment and if deployment was fully executed

See next feature

Find and mask sensitive data

Mask sensitive data in provisioned databases

See next feature

Provision a database

Use database cloning method for provisioning

See next feature

Octopus Deploy

Ready to use visual templates for database project deployments

See next feature

Continuous database integration

Continuous database integration

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 is a database DevOps tool 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.

Continuous database delivery

Continuous database delivery

ApexSQL DevOps toolkit dashboard – Screen shot tour

This article represents a screen shot tour of ApexSQL DevOps Web dashboard features with a brief description

Requirements and recommendations for database continuous integration and continuous delivery workflows

Basic need-to-know about ApexSQL solutions for database DevOps tool

How to setup continuous integration and continuous delivery tasks using the ApexSQL DevOps toolkit - Azure DevOps Server (TFS) / Azure DevOps Services plugin

This article explains how to setup continuous integration and continuous delivery tasks using the ApexSQL DevOps toolkit

How to setup continuous integration and continuous delivery tasks using the ApexSQL DevOps toolkit Bamboo plugin

This article explains steps to setup continuous integration and continuous delivery tasks using the ApexSQL DevOps toolkit Bamboo plugin

ApexSQL CICD toolkit wins DevOps 2020 Innovator Product Excellence award for Continuous Database Integration

ApexSQL DevOps toolkit (formerly ApexSQL CICD toolkit) is a recipient of the DevOps 2020 Innovator Product Excellence award in the category of Continuous Database Integration

An introduction to ApexSQL DevOps toolkit Web Dashboard – pipeline steps overview

This video shows steps for making the pipelines using ApexSQL DevOps toolkit Web Dashboard

An introduction to SQL Server database continuous integration with the ApexSQL DevOps toolkit - TeamCity plugin

This video shows steps for making the Continuous integration pipelines using ApexSQL DevOps toolkit - TeamCity plugin.

An introduction to SQL Server database continuous delivery with the ApexSQL DevOps toolkit - TeamCity plugin

This video shows steps for making the Continuous delivery pipelines using ApexSQL DevOps toolkit - TeamCity plugin.

Advantages of ApexSQL DevOps toolkit PowerShell scripts

This article shows the main advantages of using ApexSQL DevOps toolkit PowerShell scripts

Advantages of ApexSQL DevOps toolkit Web dashboard

This article shows the main advantages of using ApexSQL DevOps toolkit Web dashboard

What’s new in ApexSQL Developer: ApexSQL DevOps toolkit Web dashboard

This article introduces new feature of ApexSQL DevOps toolkit - a standalone web dashboard

What’s new in ApexSQL DevOps toolkit – TeamCity build server plugin

This article introduces new feature of ApexSQL DevOps toolkit - a TeamCity plugin

See more
Bamboo TeamCity Jenkins Visual Studio
AppVeyor CI Go Continuous Delivery Cruise Control CI Hudson CI
ApexSQL Redgate®
SQL Server version
      SQL Server 2005
      SQL Server 2008 - 2017
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Amazon RDS for SQL Server [1]
Interface
      PowerShell cmdlets
      Visual Studio add-in
      SQL Server Management Studio (SSMS) add-in
      Web dashboard
Native plugins
      Azure DevOps Server (TFS) / Azure DevOps Services
      Bamboo
      Jenkins
      Octopus Deploy
      TeamCity
PowerShell integration
      AppVeyor
      Azure DevOps
      Azure DevOps Server (TFS)
      Bamboo
      CruiseControl
      GoCD
      Hudson CI
      Jenkins
      Octopus Deploy
      TeamCity
      Any other CI server with PowerShell support
General features
      Archive all output files in a central folder
      Automatically create rollback scripts
      Build a database directly from source control
      Check for invalid objects
      Create deployment package
      Flexible pipeline creation
      Generate synthetic test data
      Get notified when changes are detected in source control, before a build starts
      Include static data in builds
      Pre/post deployment schema check of the target database
      Report on changes
      Review database based on built-in and custom written rules
      Run SQL unit tests
      Synchronize target database with source control
      Trigger an automated build on changes in source control
      State based database delivery
      Migration based database delivery
      Audit sensitive tables with DML triggers
      Automatically stop pipeline execution on found rulebase violations
      Deploy custom PowerShell scripts
      Format/obfuscate SQL code
      Mask sensitive data
Inputs
      Script folder
      Source control
      SQL Server database
      SQL project
      SQL script
Trigger
      Manually
      On a schedule
      On changes in source control
Continuous integration steps
      Build
      Document
      Package
      Populate
      Review
      Test
      Audit
Continuous delivery steps
      Deploy
      Sync
      Sync data
      Compare
      Mask
      Provision
General steps
      Notify
      Publish
      Custom
Source control system support
      Azure DevOps Server (TFS) Native Native
      Git Native Native
      Subversion Native Native
      Mercurial Native CLI
      Perforce Native CLI
Other
      Publish NuGet packages
      Export/Import output packages in Zip format
      Customizable data sources
      Documentation of database changes only
      Open sourced PowerShell code downloadable from GitHub
      Configuration through individual step project files
Price
Free $2,495

[1] SQL unit tests for Amazon RDS for SQL Server will be available in Q3 2019


ApexSQL DevOps toolkit 2019 R3

Redgate® SQL Change Automation 4.0.19259


Comparison was conducted on September 20, 2019

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

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. TeamCity. customizable workflow builder supports any pipeline configuration.

Free

This database DevOps tool is free and requires no additional purchase, 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.

Testimonials

I have worked for 18 yrs as a developer and for the past 5 yrs I have been an application manager, never have I seen a prompt response in my career. Worked with tons of products most of them not as good, but kudos to you man, you have got a great product and promising support.

Trenton D Souza

Application Manager

Clinical NetwoRx

Thanks for great products!

John Saunders

Microsoft MVP

Connected System Developer

Other free tools

Comparison

Script, file and folder comparison

Learn more

Decryption

Database object decryption

Learn more

Discovery

SQL Server instance discovery

Learn more

Formatting

SQL formatting and refactors

Learn more

Modeling

SQL Server database modeling

Learn more

Plan exploring

Query execution plan exploration and analysis

Learn more

Productivity

Improved SQL coding and productivity

Learn more

Propagation

Multi-database script execution

Learn more

Search

SQL text and object search

Learn more

© 2019 Quest Software Inc. ALL RIGHTS RESERVED.   |   1-800-306-9329   |   sales@apexsql.com   |   GDPR   |   Terms of Use   |   Privacy