Redgate Launches Extension for SQL Operations Studio
May 14, 2018

The latest Public Preview release of SQL Operations Studio, a cross-platform database development tool from Microsoft, has been enhanced with an extension from Redgate Software.

Redgate has further developed its free SQL Search tool to integrate with and plug into SQL Operations Studio.

Built on top of Visual Studio Code, SQL Operations Studio is a free lightweight tool for modern database development and operations that runs on Windows, macOS and Linux. It’s been designed for developers without a deep knowledge of database administration, so that they can manage databases and maintain them.

SQL Search is the most popular tool Redgate has ever developed and the version for SQL Server Management Studio and Visual Studio 2017 has been downloaded more than half a million times. It saves developers time and removes frustration by finding fragments of SQL in tables, views, stored procedures, functions, and jobs. Importantly, it also searches across multiple object types and databases, and allows users to quickly navigate to wherever the fragments happen to be on a server.

The new extension for SQL Operations Studio gives developers who prefer this cross-platform tool the same functionality on the Windows, macOS or Linux platform. It was developed by Foundry, the Research & Development division of Redgate, to discover the appeal of Redgate extensions for cross-platform use, and explore the challenges of creating tools in the space.

The launch is an important one because, as Redgate’s 2018 State of Database DevOps Survey shows, 76% of organizations have developers in their team who work across both applications and databases. Their greatest challenge is synchronizing the application and database changes, and overcoming different approaches to development within multi-function teams.

SQL Operations Studio addresses part of the challenge by allowing developers to stay with their favored platform as they move between application and database development. Microsoft also, however, wants to build what it calls a rich tools eco-system for SQL Operations Studio, and its fourth major update in March included an Extension Manager to make it simple to discover and acquire additional functionality.

The Preview release of the SQL Search extension for SQL Operations Studio is now available and is the first step on Redgate’s cross-platform journey. As Jonathan Roberts, the Foundry Team Lead explains: “Redgate has a complete portfolio of database development tools which plug into SQL Server Management Studio and Visual Studio 2017 and bring DevOps to databases. We want to find out what added functionality users of SQL Operations Studio want, and how we can help deliver it to them. SQL Search is a natural extension to begin with because it’s a relatively small tool and the task of adapting it for macOS and Linux gave us some valuable insights.”

SQL Search is a recommended extension for SQL Operations Studio and can be downloaded through its Extension Manager Marketplace. Once installed, it can be used from within SQL Operations Studio in, literally, a couple of clicks and becomes part of the natural workflow.

The Foundry team is now actively seeking feedback from users to determine the next step on the cross-platform journey.

The Latest

November 15, 2018

Serverless infrastructure environments are set to become the dominant paradigm for enterprise technology deployments, according to a new report — Why the Fuss About Serverless? — released by Leading Edge Forum ...

November 14, 2018

What to automate? Which parts of the delivery process are good candidates? Which applications will benefit from automation? At first, those sound like silly questions. Automate all your repetitive processes. If you think that you'll do the same thing manually more than once, automate it. Why would you waste your creative potential and knowledge by doing things that are much better done by scripts? Yet, an average company does not adhere to that logic. Why is that? ...

November 13, 2018

I'd love to see more security automation deeply integrated into the development process. Everybody knows since the 1990s that security as an afterthought just doesn't work, yet we keep doing it. The reason, I think, is because it's very hard to automate security ...

November 09, 2018

DEVOPSdigest asked experts from across the IT industry for their opinions on what steps in the SDLC should be automated. Part 5, the final installment, covers deployment and production ...

November 08, 2018

DEVOPSdigest asked experts from across the IT industry for their opinions on what steps in the SDLC should be automated. Part 4 is all about security ...

November 07, 2018

DEVOPSdigest asked experts from across the IT industry for their opinions on what steps in the SDLC should be automated. Part 3 covers the development environment and the infrastructure ...

November 06, 2018

DEVOPSdigest asked experts from across the IT industry for their opinions on what steps in the SDLC should be automated. Part 2 covers the coding process ...

November 05, 2018

Everyone talks about automating the software development lifecycle (SDLC) but the first question should be: What should you automate? With this question in mind, DEVOPSdigest asked experts from across the IT industry for their opinions on what steps in the SDLC should be automated. Part 1 starts with by-far the most popular recommendation: Testing ...

October 31, 2018

Halloween is a time for all things spooky, but not when it comes to your mobile app experience. A poor experience can not only scare off your customers but keep them away for good ...

October 30, 2018

As organizations have embraced open source, they have become polyglot — using multiple programming languages and technology stacks to accomplish software and hardware related tasks. Enterprises are caught between the benefits provided by a polyglot environment and the complexities and challenges these environments bring. Ultimately, if the situation remains unchecked, polyglot will kill your enterprise ...

Share this