PowerShell+ 2019 - Continuously deploying SQL code using Powershell by Kirill Kravtsov
About this talk
There are many tools on the market that will help you to deploy your code, but, very often, they either binding you to a certain framework, preventing you from using any other products, or are not flexible enough to accommodate for all the deployment requirements. This session will help you to discover multiple scenarios of deploying SQL code to your databases using nothing, but Powershell: - Ad-hoc deployments to a database server using a set of SQL scripts - Using configurations to deploy to multiple environments - Using code packaging capabilities to deploy your code within a CD pipeline framework - Set up continuous integration of SQL code into a CI database - Deploy directly from Source Control repositories using Jenkins jobs All the deployments will be done in a fully customizable manner that embraces multiple database types (SQL Server, Oracle, MySql, Postgre - you name it!) and helps administrators to reduce the possibility of a human error during the deployments. Deployment scenarios will include building deployment pipelines in Jenkins, which is a perfect (and open-source) tool to configure a user-friendly interface for your Powershell scripts. All the deployment features are provided by DBOps Powershell module, which has a number of features: - Powered by DbUp - highly customizable open-source .Net project, that provides a complex framework of deploying any kind of SQL code. - Module is using Powershell 5.0 and comes with a user-friendly class structure that allows for even deeper customization. - Contains all the necessary commands to provide end-to-end support for CI/CD SQL code deployment pipelines. - Thoroughly tested with hundreds of Pester tests to ensure flawless deployments PowerShell Summit videos are recorded on a "best effort" basis. We use a room mic to capture as much room audio as possible, with an emphasis on capturing the speaker. Our recordings are made in a way that minimizes overhead for our speakers and interruptions to our live audience. These recordings are meant to preserve the presentations' information for posterity, and are not intended to be a substitute for attending the Summit in person. These recordings are not intended as professional video training products. We hope you find these videos useful - the equipment used to record these was purchased using generous donations from members of the PowerShell community.
Stay Updated
Get notified about new features and conference additions.