8
Vote

Data Scrambling or Masking

description

Please add the data Scrambling/Masking code samples because I have not seen any libraries or code samples to cover the data scrambling or masking (not to mix with Obfuscating data which is more about hiding the content) so far any where.
This is often required to allow realistic testing off a subset of data from production systems by software testers or developers who do not necessarily have the privilege to see the "live" data.

comments

mapeng wrote Aug 23, 2012 at 2:59 AM

Hello arthurz,

Thank you for using our free Microsoft All-In-One Code Framework Sample Request Service!

Your sample request is about how to implement Data Scrambling/Masking. If I misunderstood your requirement, please feel free to let me know.

According to the different scenarios, there are different restrictions and different scrambling methods, such as use the scripts, custom define the functions, and the SSIS package. If you can provide more information, it will be very helpful for us to design this sample, or we can only brain it. The following links is the sample about how to implement the basic Data Scrambling using the SSIS:
http://ssisdatamasker.codeplex.com/.
Please let us know if this sample is helpful to you.

Thanks and have a great day!

Microsoft All-In-One Code Framework
Feedback address: onecode@microsoft.com