Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

making dummy data out of real data

is there any existing code to totally invalidate the existing data, so that is not meaningful any more, in a test environment.

thanks
0
anushahanna
Asked:
anushahanna
  • 2
  • 2
2 Solutions
 
anushahannaAuthor Commented:
For example, 3 of the 1000s of employees maybe

*John R Singer, SSN: 123456789, Age 54, City Boston Dept Sales
*Mary K Porter, SSN 987654321, Age 42, City Atlanta, Dept Accounting
*Kumar Singh, SSN 224466880, Age 33, City Houston, Dept IT

The output maybe
*Kumar K Singer, SSN;123456789, Age 42, City Atlanta, Dept Sales
*John Porter, SSN 224466880, Age 33, City Houston Dept Accounting

etc

Thanks
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
If you want to invalidate your existing data, then you can use a masking tool like this:

http://www.datamasking.com/productdownloads.aspx
0
 
Kevin CrossChief Technology OfficerCommented:
Hi anushahanna,

Firstly, I am hopeful that the data presented above is not real-life production data.

Secondly, it is probably just as easy to do something like this:

update your_table
set full_name = left(full_name, charindex(' ', full_name)-1) + ' Smith'
  , ssn = '555-55-' + substring(ssn, 3, 4)
  , age = (age%20)*(age%5)+18 -- only harmful if full name and ssn known
  , city = 'Metropolis' -- could also not change
  , dept = dept -- doesn't really need changing

Just demonstrating that this should be simple enough. Not sure you need an additional bit of software to do this.
0
 
Kevin CrossChief Technology OfficerCommented:
Nice like Raja. Will have to check that out.
0
 
anushahannaAuthor Commented:
both are creative options. I will check the feasibility with the users.

Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now