When the process of introducing application changes is separated from the process of introducing database changes, it’s easy for dependent changes to become out of sync. With the Database Code Packager, teams can check their SQL Scripts into the application’s source code repository creating a complete change package in a single secure location. The Database Code Packager then performs several levels of automated validation during the application build, enabling true database continuous delivery.
Unify Application and Database Changes.
As part of an organization’s existing application build process, Datical retrieves, validates and labels database changes making it easy to trace changes back to the corresponding application task or business requirement. The result is a complete package of application and database changes that can be easily promoted to or removed from an environment or planned release in lock step.
Develop, Branch and Merge Database Code Like Application Code
Datical’s integration with source code control repositories allows development teams to take advantage of the same branching and merging strategies established for their application code when managing their database changes. By including your database change scripts in the same branch and merge commands performed for application code, Datical automatically ensures merged changes are available and promoted along with the application features they support.
Improve Error Handling
When organizations rely on manual or direct execution of SQL scripts in early stage development, integration and test environments script errors become firefights. Until someone reviews the errors and fixes the issue or unwinds the changes made to the database to get it back to the last known good state, application are stuck – playing the waiting game. Datical prevents this costly downtime by automatically reverting the database environment to its last known good state and providing detailed information about any failure during the database continuous delivery process to help achieve quick resolutions.