Red Gate forums :: View topic - Lookup Data
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Lookup Data

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nolan



Joined: 28 Jun 2011
Posts: 1

PostPosted: Tue Jun 28, 2011 7:51 am    Post subject: Lookup Data Reply with quote

I'm working on a solution where I will be using Data Compare to transfer an existing database to a 'holding' db, I will then 'Mask' this data using the SQL Data Generator.
The resultant data will then be transfered to the QA environment via Data Compare again.

This solution requires multiple different databases to be 'Masked', however the data across these databases needs to be consistent, i.e. the Credit Card Number that becomes Obfuscated in both Databases needs to still be the same number when comparing these databases together (cross referencing in our applications).

I was thining of creating a lookup table, which will hold the real cc number as well as the 'created' cc number. and when I use the Generator use a SQL script to obtain the 'created' cc number.

How would I go about doing this?
Back to top
View user's profile Send private message
aolcot



Joined: 28 Jun 2011
Posts: 25

PostPosted: Wed Jun 29, 2011 8:55 am    Post subject: Reply with quote

Hi Nolan, I too have similar scenarios but the data that i work with is health related.

There is a great book called Protecting SQL Server Data by John Magnabosco/RedGate which gives looks of good information regarding securing/obfuscating data. I've got a printed copy, but i believe you can get an pdf version.

You should be able to adapt some of the examples in the book to obfuscate the cc number and then wire that logic into SQL data generator, probably using the "SQL statement" generator.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group