Database DevOps with Redgate Data Tools

Play Database DevOps with Redgate Data Tools
Sign in to queue


In this episode, Robert is joined by Steve Jones and special guest host Scott Klein to discuss database DevOps. Steve shows how you can use the Redgate Data Tools (ReadyRoll Core, SQL Prompt Core and SQL Search) that are included in Visual Studio Enterprise 2017 to extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development. 

Steve also compares the migrations-driven approach of the RedGate tools compared to the state-based approach of the SQL Server Data Tools, which were featured in last week's episode




The Discussion

  • User profile image



    I am taking a CSIS 209 class right now and it's based on Visual Studio so my teacher told me that I can find help here to comprehend Visual Studio.


    Thank you

  • User profile image

    I think that clone database is neat but it also raises some concerns about potentially having real PII or PCI data in a dev environment.

  • User profile image

    @SheldonS: good point - you certainly need to take care. [I work for Redgate on SQL Clone].

    Some of our customers are currently delivering clone databases using PowerShell batches which also 'mask' or overwrite sensitive data at time of database delivery (not appropriate for fully protecting data; the .mdf/.ldf files could still be hacked).

    Alternatively TDE still works if you control the certificate backup/restore, or you could curate some images for provisioning by replacing sensitive data with generated. Details on both on the Redgate blog.

    Meanwhile, we're actively researching masking needs with a prototype product - search for SQL Data Mask.

    We're hoping to make masking 'ingeniously simple' with an offering in our product line very soon!


  • User profile image
    what about other DevOps tools like DevOps Automation ( ), etc? Did you try them? I think Redgate tools have a lot of good alternatives.

Add Your 2 Cents