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.
You can do that by developing an SQL script that changes the data that you want to change. Then run this script after db refresh, before enabling users in the system.
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.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156