Create a safe Database for Development/Testing

14 February 2011

So we all know that developing with “REAL” data is nice however usually it's not practical as the data is sensitive and cannot be accessed out side of a production environment. So how about Data Synchronisation Studio just obfuscate the data that's sensitive and you can then use real data for development and testing.

In data sync create a mapping between a source database and your new test database. Then create some dynamic columns to obfuscate the sensitive data such as Client Name, Company Name etc.

Project

Using the ObfuscateHelper class you can obfuscate a string into something less obvious but still printable.

i.e.ObfuscateHelper.SimpleObfuscateValue(this.CompanyName);

Dynamic Columns

The results then look a bit like this where the letters are repeated keeping case and any special characters.

Compare Results

| |