CODEWITHSUNDEEP
progress-4glopenedge
Preston Martin
Preston Martin

Reputation: 2963

Modify data in a database backup file

I have a .bak file of a database that contains PHI located on a server in a PHI environment. I have a .r script that will anonymize and remove PHI data in the database and any other connections strings that point to client systems. Is there a way to run this script (or another type of script) to modify the .bak file in the PHI environment before I move it to a non-PHI compliant environment to be restored?

Upvotes: 1

Views: 349

Answers (1)

Tom Bascom
Tom Bascom

Reputation: 14020

I am guessing that a ".bak file" is a backup (there is no standard Progress-wide naming convention but that is a common usage). If so then, no, there is no way to directly manipulate the backup without restoring it.

You could restore it in a safe environment, modify the contents of the restored db and then make a new backup of the anonymized database. (If I were to do something like that I would use a different extension, perhaps .BKX, for the scrubbed backup so that it is obvious to people which one is which - that would help to reduce the chances of accidental release...)

Upvotes: 3

Related Questions