DEVOPSdigest asked experts from across the IT industry for their opinions on the top tools to support DevSecOps. Part 3 covers security and monitoring ...
Redgate Software partnered with Microsoft to integrate its Redgate Data Tools with Microsoft Visual Studio Enterprise 2017.
The addition of the Redgate tools gives users the ability to extend DevOps processes to their Microsoft SQL Server and Azure SQL databases out-of-the-box.
Redgate Data Tools includes ReadyRoll Core, SQL Prompt Core and SQL Search, and is part of the data storage and processing workload in Visual Studio 2017, which Enterprise subscribers can install at no additional cost as part of the standard installation process.
Redgate ReadyRoll Core enables users to develop, source control, and more safely automate the deployment of SQL Server database changes alongside their application changes. Similarly, SQL Prompt Core and SQL Search, Redgate’s most popular and widely used productivity tools, complement the DevOps methodology by allowing users to work more quickly and accurately with SQL.
The integration of Redgate tools with Visual Studio 2017 is a direct result of the rising interest in DevOps practices, which was highlighted in Redgate’s State of Database DevOps Survey in January 2017. The survey of 1,000 companies worldwide revealed that 47% of respondents have already adopted a DevOps approach to some or all of their projects – and a further 33% plan to adopt it during the next two years.
DevOps encourages collaboration across teams that have traditionally been split into development and operations, and results in earlier feedback on changes, and the ability to deliver value to customers more quickly and efficiently. A common hurdle, however, is the database which has unique requirements and often follows a different development process from that used for application development.
The inclusion of Redgate Data Tools in Visual Studio Enterprise 2017 creates a natural platform for both application and database development. One of the tools, SQL Search, is also included in the Community and Professional versions of Visual Studio 2017, so all users can benefit from increased productivity when working with SQL.
Simon Galbraith, Redgate CEO, is enthusiastic about the partnership. “We’ve been developing software for the Microsoft data platform for 17 years,” he says, “and we’ve always had a good relationship. Shipping the Redgate Data Tools in Visual Studio Enterprise 2017 is a sign of how strong that relationship is – and also a recognition that database DevOps is now moving into the mainstream.”
Shawn Nandi, Senior Director for Cloud App Development and Data product marketing at Microsoft Corp. added, “Redgate tools are a great option for customers who work with SQL Server and Azure SQL databases because they plug into the software they already use for application development. By including three of these tools in Visual Studio Enterprise 2017, Redgate has made it easier for customers to implement DevOps practices when building, deploying and maintaining their databases. We think this is an important step forward to help companies extend DevOps practices to all parts of their applications.”