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

October 22, 2018

Embracing DevOps at enterprise scale requires a seismic shift in the way an organization plans, builds, tests, releases, and manages applications. Here are four ways to ensure your enterprise DevOps transformation is a success ...

October 18, 2018

Are applications teams prepared to manage the chaos arising from an ever-growing landscape of heterogeneous deployment types? A recent survey of application and operations professionals sought to better understand how the industry is shifting and what the future of DevOps might look like. Here is what the survey uncovered ...

October 16, 2018

More than half of organizations have a dedicated DevOps team to help them better implement agile strategies, accelerate release cycles and ensure continuous development. However, databases have a habit of holding DevOps back ...

October 15, 2018

Test Environment Management can save organizations close to $10,000 for each release, yet only four percent of large enterprises have fully integrated TEM processes into organizational DNA, according to the 2018 Test Environment Management Survey released by EMA and Plutora ...

October 11, 2018

Agile is indeed expanding across the enterprise and there was a significant jump from last year to this year in the percentage of respondents who indicated that all or almost all of their teams were agile, according to the State of Agile 2018 report from CollabNet ...

October 09, 2018

Adopting a modern application architecture is critical to business success and a significant driver of profit growth in today’s digital economy, according to the results of a global survey of IT and business executives released by CA Technologies and conducted by Frost & Sullivan ...

October 04, 2018

How do you integrate tools to enable shift-left performance? The following tools will simplify maintenance, can be managed in a centralized way, and provide an easy-to-use UI to comprehend results ...

October 03, 2018

Focusing at the API layer of an application can help enable a scalable testing practice that can be efficiently executed as part of an accelerated delivery process, and is a practice that can be adopted and enabled at the earliest possible stages of development — truly shifting left functional testing. But what about performance testing? How do we enable the shift left of nonfunctional testing? Here, we explore what this means and how to enable it in your organization ...

October 01, 2018

As businesses look to capitalize on the benefits offered by the cloud, we've seen the rise of the DevOps practice which, in common with the cloud, offers businesses the advantages of greater agility, speed, quality and efficiency. However, achieving this agility requires end-to-end visibility based on continuous monitoring of the developed applications as part of the software development life cycle ...

September 27, 2018

Imagine that you are tasked with architecting a mission-critical cloud application. Or migrating an on-premise app to the cloud. You may ask yourself, "how do the cloud savvy companies like Airbnb, Adobe, SalesForce, etc. build and manage their modern applications?" ...

Share this