For developers and DBAs that need to deploy database changes to multiple environments reliably.
DevOps is a hot topic in today’s software development world, however most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by explaining the core concepts of managing scripts, automated building, testing, and deployment of database changes. Once you understand the principles of a DevOps database development process, you can generate scripts used for direct deployment on your instances or sent to customers for them to execute.
In this session we will cover tracking the changes made to your database and capturing them in version control. We will show automated building and testing of your code on a separate environment and the generation of an upgrade script that a DBA and developer can review and deploy to QA, test, staging, production, or any other environment.
This session will use Redgate Software tools to accomplish specific actions, with explanations on how the same actions can be alternatively built by anyone.
Why I Want to Present This Session:
I’d like to help more developers and DBAs understand the process of streamlining their deployment process through a DevOps mentality and automated tools. By explaining the general process and concepts, and showing specific implementations, DBAs and developers can gain confidence in experimenting with a proof of concept in their environment that can help them build a repeatable and reliable database software deployment pipeline.