February 12, 2009 at 6:30 am
I am a dba in a hospital. Sometimes our suppliers need to take a copy of their database to restore it on their servers and make updates or improvements. I would like to give them a copy of the db, crypting personal data such as name, surname, ...
I'm thinking to create system jobs which restore the databases from the production server on a dedicated server, and then execute queries which overwrite some columns containt (maybe I could ask the suppliers to give me a list of tables containing personal data), and then make a bakup.
Is there a better way? Has anyone good suggestions?
Thanks in advance.
sb
February 12, 2009 at 6:58 am
I do this with my suppliers.
Restore a copy of the production environment to the test environment.
Then run some scripts to delete data or change data.
February 12, 2009 at 7:03 am
Well, here is the thing:
Have you got any backups scheduled already for your DR plan? If so, you don't want to affect your overall backup sets. you can create COPY_ONLY backups and restore them to your dedicated server and work form there.
Check BOL for thse kind of backups
February 12, 2009 at 1:13 pm
Both of the suggestions above are what I'd recommend, but I'd also have "obfuscation scripts" ready and running when you need to update test or dev from production as well.
February 13, 2009 at 2:19 am
Thanks a lot, the hardest work will be to prepare for each database the scripts to delete unwanted data...
Very useful the COPY_DATA option, many thanks!
sb
February 13, 2009 at 6:02 am
pixye.sb (2/13/2009)
Very useful the COPY_DATA option
COPY_ONLY backups.
No problem, its our pleasure:)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply