Efficient development processes are based on automated processes to test, integrate, and deploy applications into production. With typical applications, this is quite an easy task. For database applications, it’s a bit harder. This article explains why and how to execute this process successfully.
Some time ago, I wrote about the Challenges in Automating Multi-Schema Database Deployments. It was about why automated database deployments are crucial to efficient development processes and why they are challenging to establish with multi-schema applications.
After implementing many automated DWH deployment processes, I now summarized the most important steps to get there and explain why not only technological implementations have to be made but also process changes and why they are crucial.
Manual deployments include all the processes that require manual steps to install your software into production. Those manual steps can be:
Emailing the install scripts to other people (lack of centralized repository).
Manual execution of installation scripts (lack of automated pipelines).
Copying files around (lack of centralized repository).
Sending emails (lack of automated processes).
People outside the team execute the installation (lack of ownership).
Example of a manual deployment process where communication happens over email.
In the picture above, an example of a manual deployment process is shown. The team member sends an installation package over email to the DBA. The DBA then manually installs the scripts on the target database. He then sends an email back to the team member with a message if the deployment was successful or not. If it wasn’t, he attaches a log file with the error. The team member then has to start looking for the problem and sends a fix again to the DBA…
Hire our Dedicated DevOps Developers who have in-depth skills and expertise to develop an interactive and secure web application. Get custom DevOps solutions for your project.
Looking to hire top DevOps developers at affordable prices? **[Hire DevOps Developer](https://hourlydeveloper.io/hire-dedicated-devops-developer/ "Hire DevOps Developer")** from **[HourlyDeveloper.io](https://hourlydeveloper.io/...
DevOps is supposed to help streamline the process of taking code changes and getting them to production for users to enjoy. But what exactly does it mean for the process to be "streamlined"? One way to answer this is to start measuring metrics.
This article covers A-Z about the mobile and web app development process and answers your question on how long does it take to develop/build an app.
With great power comes great responsibility. More and more organisations are moving towards a DevOps based organisational model, putting more and more respon...