30 November 2017

6 Comments

30 November 2017

6 Comments

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.

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

Related posts

Also in Software development

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...

Also in Blog

Join Gene Kim in a live webinar about where the database fits in DevOps

A couple of weeks ago, the 2018 Accelerate State of DevOps Report from DORA was published which, for the first time, included database development as a key technical practice which can drive high perf...

Also about Foundry

Reducing risk with Smart Recommendations in SQL Census

One of the most prominent subjects of the last few months within organizations in many industries across the globe has been centered around data security. Organizational compliance with regulations su...

  • 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)