ApexSQL DevOps Toolkit

Database DevOps Tool

SQL database DevOps tool to implement continuous integration and delivery (CI CD)

• 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

Web Dashboard

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

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

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

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

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

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

Activity View

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

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

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

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.

Azure DevOps Server Build Server Plug-in

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

Jenkins Build Server Plug-in

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

Bamboo Build Server Plug-in

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

Themes

Choose between dark and light colored layouts

Custom Step

Execute custom PowerShell scripts during database pipeline execution

Validate

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

Find and Mask Sensitive Data

Mask sensitive data in provisioned databases

Provision a Database

Use database cloning method for provisioning

Octopus Deploy

Ready to use visual templates for database project deployments