Database DevOps with Redgate Data Tools

Sign in to queue

The Discussion

  • User profile image
    Jayn

    Hello,

     

    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
    SheldonS

    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
    Richard​Macaskill

    @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!

    Richard

Add Your 2 Cents