Encrypting or updating data in development

  • Is there an easy update statement or encryption function to encrypt specific column data within tables? For example, account information, social security info, salary, etc.... that allows developers to continue working with fake data or encrypted data.

    ¤ §unshine ¤

  • Try this article[/url]

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Very cool for only one column within a table. What about multiple? I see this is becoming a huge project now :(.

    Thank you so muhc for your help!

    ¤ §unshine ¤

  • It could very well be a large project. However, it could prove very useful. If it could ensure accurate testing, reduce development time due to an environment more like prod - it could prove very fruitful.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply