sql - Backup database and remove sensitive data -
i'm looking @ backup routine allows our production database backed sensitive data stripped out of columns within database exported our testing server.
the routine should require least human intervention , simple customisable sql script without taking production database offline.
database server sql server 2008.
i've run similar requirements before, , sure solution know of use copy of production database. can mask/delete data on copy , run backups there. yes it's ugly , waste of resources, date haven't found solid alternative particular problem.
as copy method, have options:
- replication
- scheduled db copy
- backup/restore production
so while admit solution pretty cringe-worthy, can automated , serve purposes. if can find productive uses database copy don't require deleted information (e.g. reports, testing, development) can less-than-terrible solution. can nice security boon have out-of-date version of production database sensitive data removed.
Comments
Post a Comment