{"repo":"dataplat/dbops","free":true,"listed":false,"github":"https://github.com/dataplat/dbops","clone":"git clone https://github.com/dataplat/dbops.git","description":"⚙ dbops - Powershell module that provides continuous database deployments on any scale","language":"PowerShell","stars":177,"topics":["dbops","powershell","hacktoberfest","database"],"license":"MIT","category":"databases-storage","readme_excerpt":"master development --- --- DBOps DBOps is a Powershell module that provides Continuous Integration/Continuous Deployment capabilities for SQL database deployments. In addition to easy-to-use deployment functions, it provides tracking functionality, ensuring that each script is deployed only once and in due order. It will also grant you with ability to organize scripts into builds and deploy them in a repeatable manner on top of any previously deployed version. The deployment functionality of the module is provided by DbUp .Net library, which has proven its flexibility and reliability during deployments. Currently supported RDBMS: SQL Server Oracle PostgreSQL MySQL In addition it also supports Azure Synapse Analytics SQL Pools (both dedicated and serverless). Be aware that you cannot use the schemaversion table with the serverless SQL Pool - it needs to be explicitly disabled by setting SchemaVersionTable to $null . All scripts deployed in such scenario should be idempotent and re-runnable. Features The most notable features of the module: Reliably deploy your scripts in a consistent and repeatable manner Perform ad-hoc deployments with highly customizable deployment parameters Run ad-hoc queries to any supported RDBMS on both Windows and Linux Create ready-to-deploy versioned packages in a single command Brings along all features of CI/CD pipelining functionality: builds, artifact management, deployment Roll back the script (or a whole deployment!) in case of errors Dynamical","default_branch":null,"files":null,"tree":[],"storefront":"/r/dataplat","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dataplat/dbops/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}