DBmaestro DevOps Automation

DBmaestro’s Database DevOps Platform includes the Release Automation Module, which enables teams to automate deployments. The tool provides the ability to model the release process and path to production, predicting errors or conflicts that might prevent a successful deployment.

DBmaestro Release Automation enables organizations to:

• Avoid human error with automated validity checks as part of the automated release pipeline
• Prevent accidental overrides of changes or critical fixes
• Receive notification for database drifts
• See a complete audit trail containing a full history of all changes made to the database
• Create roles and permissions to instill governance that meets company policy and promotes security
• Receive analyses of database health and productivity
• Keep working with standard SQL coding, without requiring any intermediate language like XML or an associated translator

True view of the database

A visual database pipeline builder enables organizations to package, verify, deploy, and promote database changes, enabling teams to build and visualize a full delivery pipeline. The tool can identify any configuration drift that might prevent a successful release, making sure upgrade scripts comply with company policy and preventing rogue code from running.

The Release Automation Module revalidates the final state, to make sure the release process ended successfully, while auditing all changes made. This tool supports any existing source control tool, (Git, SVN and others), as well as DBmaestro’s Versioning Module.

Control roles and security

Prevent security breaches and control database activities by defining roles for all team members. You can define roles down to the object and data level. Enforce the separation of duties and permissions and stop unauthorized changes to the database.

The platform’s Policy Engine enables you to set and enforce specific organizational policy parameters. Determine which operations are allowed and which are forbidden, set the scope and timing of policy execution, enforce company-wide coding standards and more. The Policy Engine keeps anyone who works on database development in line with company standards and helps prevent critical errors and downtime.

Audit trail of all changes made (and attempted)

The module creates a complete history of all changes made, down to the object type and the schema. With roles put in place in advance, you have full transparency of all activities and a documented history in place in case rollbacks are required.

Measure successes, improve failures

DBmaestro’s Database DevOps Platform includes the Business Activity Monitor, which provides insights into the release process – enabling you to measure and identify successes and trends. See how often code is deployed, which deployments are failing, and how long it takes to get an upgrade into production (lead time).

Tools and Pricing

This plugin is designed to work with the full DBmaestro Database DevOps Platform, which includes the following:

• Release Automation Module
• Versioning Module
• Policy Management, Auditability and Security Module
• Business Activity Monitor

All are fully compatible out-of-the-box with Visual Studio, and work smoothly with SQL Server Data Tools (SSDT). DBmaestro Database DevOps Platform follows a subscription pricing model. DBmaestro offers several pricing packages based on the organization’s specific needs. Please contact DBmaestro sales: sales@dbmaestro.com