Home Forums SQL Server 2014 Development - SQL Server 2014 any tool that obfuscates an entire database schema? RE: any tool that obfuscates an entire database schema?

  • May 6, 2016 at 11:01 am

    #1877211

    SqlBarbarian (5/6/2016)

    thanks! Exactly what I'm wonder. With SQL Sentry Plan explorer they anonymize to "column1", but all the column references in plan are consistent. So I was thinking something would take the schema and just abstract actual names to generic names, but they'd still keep everything consistent in FK.

    Haven't found anything yet 🙂

    well within the Plan, it's really just a find and replace in the XML; it's a self contained cosmos, so it's good target for that, but the overall schema, it's a bit bigger, a lot harder to obfuscate, as we are seeing now.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!