30 November 2017


30 November 2017


Would you like to see Redgate tools inside SQL Operations Studio?

You may already have heard about Microsoft’s new DevOps platform for database development, SQL Operations Studio, or “SQL Ops Studio”. The preview version was announced at PASS Summit on 1 November, and Foundry, the R&D division of Redgate has been researching the feasibility, practicality and appeal of cross-platform data tools for a while.

You can play a big part in what happens next.

What is SQL Operations Studio?

SQL Operations Studio

Built on top of Visual Studio Code, SQL Ops 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.

What’s different?

One of the most surprising revelations of Redgate’s 2017 State of Database DevOps Survey was that 75% of developers are responsible for developing both the application and the database. That’s why SQL Ops Studio has so much potential.

SQL Ops Studio has introduced itself with the look and interactive style of Visual Studio Code, and looks set to build on that by introducing some of the more familiar features for dealing with data. It’s relatively easy to get up and running, and will probably become the favored go-to tool for application developers.

What’s your opinion?

What do you think of SQL Ops Studio? Have you tried it? Are you or your organization already working across multiple platforms (Windows, macOS, Linux)?

Like every Foundry project, we rely on your expertise and experience to help us understand the potential and create a solution. We’d like to hear about your thoughts and plans.

We’ll always endeavor to compensate you for your time; be it with an Amazon Gift Card, paying particular attention to your requirements or even a free license of the software that’s developed as a result, so please sign up to participate in our cross-platform data tools research project.

  • Will Spurgeon

    Yep, definitely would love to see SQL Prompt formatting options for OpsStudio, as I’m guessing it will eventually be the defacto tool for most SQL developers.

  • Paulo Correia

    I think, it’s a must

  • Denis Voituron

    Yes… it’s will be great 🙂
    SSMS is not really for developers, but OpsStudio is created for us… So, to use the best SQL extension in this tool will be very interesting.

  • Matthew Clark

    I believe SQL Prompt would need to be a plugin too for Ops Studio. Im looking into SQL Prompt for 20-40 devs but think need to wait to see what happes on Ops Studio as that seems like should be a move for us as well for better productivity.

  • Aymel Sanchez

    Yes, for sure. A must!

  • Would be nice to make a plugin that covers what Visual Studio Database Project does for us:

    1) It can compare my database with scripts in my project, syncing them (so I can put all my database structure on the source control)

    2) It can run pre and post scripts (I use it to run MERGE scripts, so my database in dev, homolog and prod are always seeded with the right data (which is in my source control)). Big failure here: both SSMS and Visual Studio fail to run a huge MERGE script (for instance: in Brazil, we have 980000 zip codes, and it is impossible to seed this data =. So, I use Redgate data compare to fill my database (in other words: I can’t do continuous deployment because the tools fail)

    3) I can rename a column in Visual Studio and it generates a change tracking for all those changes, so the deployment knows when a column must be altered instead of dropped and recreated (this would delete its data)

    But the price must be reasonable… Redgate tools are too expensive for some countries (like Brazil, where USD is about 4x our currency and the incoming of 70% of population is about US$ 500 per month)

Related posts

Also in Blog

Have your say on the state of database monitoring in 2020

Since 2018, over 1,400 SQL Server professionals have provided valuable insights into how they monitor and manage their estates, and what challenges they’re facing, through the only industry-wide sur...

Also in Software development

A message from our CEO about COVID-19

As the impact of COVID-19 increases across the globe, I wanted to explain the steps we’re taking to ensure continuity of customer service during the coming weeks.

We aim to maintain the level of ...

Also about Foundry

SQL Server Configuration — the Redgate survey results

In the Foundry Team at Redgate, we’ve been looking into how data professionals manage the complexities of their wider data estates. One aspect of this is configuring, deploying and monitoring dr...

Also about SQL Operations Studio

Welcome to Redgate tools for SQL Operations Studio

The Preview release of Microsoft’s SQL Operations Studio marks a big change in database development. Following on from the ability to run SQL Server 2017 on Linux, it makes the promise of cross-plat...