You’re offline. This is a read only version of the page.
7
Hi,
After copying the data from Prod environment to test environment, some users get more access for testing purposes, but i don't want them to see the actual data , i want them to see data only which meaningless
so if i have customers in the database i want it to be mixed up or salaries to be changed,
any idea how that can be done ? does Microsoft has something like that ? or does anyone has any custom SQL code to apply on the database ?
Thanks,
We (KingswaySoft) offer a Data Anonymizer component that runs within SSIS pipeline and it can take any data, anonymize it before writing to a different system. This is part of our SSIS Productivity Pack product offering, which you can use along with our Dynamics toolkit (which has been mentioned in this thread).
This can be achieved with scrubbing data with SQL scripts. You have to write your own SQL scripts to manipulate the data. We are doing like this in our environments.
There's no 365 tool to obfuscate data after a DB refresh, the process only cleans the standard elements that are not copied after a refresh.
If you really need this you'll have to do the extra work. Check Azure SQL Dynamics data masking (you'd need to export and import data which I don't know if it's worth the time) or some tools like Kingswaysoft and SSIS. Maybe it's easier to do the testing with the Contoso DB and add some random data from the customizations you have (if there's not a lot of them). But anyway, I think something like this requires to invest some time whatever is the solution you choose.
Adrià Ariste - Senior technical consultant @ Axazure - Read my blog!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (