What are the challenges you face when working across database platforms? Take the survey
Options

Mask data from existing source

vortexvortex Posts: 2
edited March 8, 2017 8:13AM in SQL Backup Previous Versions
Hi Guys,

I'm trying to prepare Development data from Production data . I'd like to mask sensitive production data and ID's ( foreign keys , primary keys )


Is there any way to mask ID's ( primary key , foreign key ) of Production data ?

I have gone through this documentation to mask sensitive data : https://documentation.red-gate.com/disp ... ata+source
could not find how to mask database keys . Need help at this part.

Comments

  • Options
    Hi Vortex,

    Thanks for posting on the Redgate forums.

    Are you able to be more specific about where in the instructions you are having problems? I was able to follow these and mask PK and foreign keys across two tables.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.