DEVOPSdigest

Devart, a Czech software vendor of database tools and data connectivity solutions, has released dbForge DevOps Automation for SQL Server.

Powered by the tools from dbForge Developer Bundle and embracing cutting-edge DevOps practices, the solution brings a new approach to conventional database development. The tool drastically reduces overall database release costs, minimizes deployment risks, energizes quality & update frequency, makes the workflow consistent and safe.

dbForge DevOps Automation for SQL Server is a free product supplied exclusively as a part of dbForge Developer Bundle for SQL Server. Currently, it consists of two components:

- dbForge DevOps Automation PowerShell for SQL Server

- dbForge DevOps Automation for SQL Server Plugin

The DevOps Automation PowerShell Module is a matter of the team’s particular pride. It is capable of fine-tuning and automating a vast variety of SQL Server database development tasks:

- Build – deploys a database either on LocalDB or on a specified SQL Server and generates a NuGet package from a source control repository.

- Test – runs tSQLt and generates test data.

- Sync – deploys a NuGet package and synchronizes it with a working DB.

- Publish – places a NuGet Package to a NuGet feed for further deployment.

At the same time, the solution also allows setting up DevOps processes in Jenkins with the help of the open-source dbForge DevOps Automation for SQL Server Plugin. In the near future, the company plans to extend the range of supported automation servers.