Change Policy Enforcement
DBmaestro Database DevOps Platform’s change policy enforcement is a unique technology designed to make sure that your database’s changes are following due change process and are always logged and saved. Change policy enforcement is integrated with the database engine to make sure it is never bypassed. This unique technology makes sure there are no “out of process changes”. If change policy was not enforced in the database engine, but rather through an application, one could easily bypass it by using another Oracle client tool, various IDEs or even with command line tools. DBmaestro’s Database DevOps Platform makes sure out of process changes are denied execution, and prevented before creating any damage to the database, or your company’s due processes.
To execute a command that changes a database object, the DBA or database developer must use the Check-Out Action to unlock the object withinDBmaestro’s Database DevOps Platform. This action guarantees that each change is documented correctly. After the DBA or database developer completes the changes and performs the Check-In Action, DBmaestro’s Database DevOps Platform closes the change cycle by saving the object’s new definition in the repository and setting the object’s status to “locked”.
Code overrides that can happen when two developers are trying to update the same object are easily prevented using the Check-Out & Check-In actions.
The same enforcement protocol is used to deal with application meta-data that exists in configuration tables or any other relevant content that requires revision control or SQL change tracking.
By controlling the change cycle, DBmaestro TeamWork produces an accurate audit trail of changes to the database, correlating each change (What) with the person who made it (Who), the date and time of the change (When) and the business requirement for the change (Why). DBmaestro TeamWork enables users to review the history of a single object or the entire schema and provides the capability to drill down to the change itself.
Development Process Management
DBmaestro’s Database DevOps Platform is the Database Change Management solution that brings the benefits of Software Change Management (SCM) methodologies to the database world.
When most project managers implement SCM solutions to protect development assets, their main focus is on native code (Java, C#, C++, etc…). However, in database applications, much of the data-driven code is in the database itself.
A complete SCM solution requires all application code, both native and database code, to be under version control. Every change must be documented. This requirement is easy to implement when dealing with text files containing native code. Dealing with database code is much more complex.
Later, when the need arises to deploy changes to another environment and deal with potential conflicts and code merges, TeamWork handles this task automatically, while saving countless work hours.
Let DBmaestro’s Database DevOps Platform automate these tasks for you, and help you focus on the talk at hand: completing required changes as efficiently as possible.
Use DBmaestro’s Database DevOps Platform today to make your database development environment more accurate, more efficient and more secure.