1

How we can manage database part in DevOps environment/CICD pipeline, Here taking about the SQL Script. For Example any deployment where Insert and Update SQL's, If we setup in CICD pipeline then I will execute everytime thus I will re-execute everytime & DevOps scenarios are fail in this situation.

Overall How we can setup pipeline with SQL script and Application in real world and In case of rollback, How can we manage it ?

Improve this question

1 Answer 1

Reset to default
2

There are a few different things you can do:

  1. In your CI process, run your new SQL update scripts against a Dockerized SQL Server. This will allow your CI server to reject the changes if there are basic errors in the script.
  2. If you are fully containerized look into tools like Kubernetes. These tools have ways to handle rolling back failed production updates.
  3. Utilize a Blue Green Deployment strategy along with integration testing. This provides a fallback in case things go wrong and allows for different types of automated testing schemes in your CI process.
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.