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 with Database Continuous Delivery.
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 enabling end to end database continuous deployment.
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. Take it one step further with Datical’s database change management tools and simulate the impact of changes before they are ever deployed.
Improve Error Handling
Bringing continuous delivery to database changes is not easy. When organizations rely on manual or direct execution of SQL scripts in early stage development, integration and test environments fixing script errors become firefights. Until someone reviews the errors, fixes the issue or unwinds the changes made to the database to get it back to the last known good state, application are stuck and continuous delivery grinds to a halt. Datical prevents this costly waiting game 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.