We have to do testing on DNN sites regularly, eg. for upgrading, modules updates etc.
Our normal way of working is to make a back-up of the production site, restore it on a test server, changing portal alias, DB etc.in de web.config and start testing.
What we would like to do as well, is anonymizing the users in the standard user table(s).
Does anyone have an SQL script or procedure to do so? And are you willing to share that script?
Michael TobischDNN★MVP
Maybe Ask Peter donker about the code he added for GDPR, I'm not 100% sure but I think there's code to anonimize users for GDPR in the framework.
We can try to solve the whole world in one giant leap forward, but that was not my intention. I just want a small step at the time: anonymizing a local copy of a complete site.
Just randomize, so name & email adddress is randomized for all portals.
Here's a simple query I use: --Remove Email Addresses from Users Table Update Users Set Email = convert(nvarchar(255),UserID) + '@test.com' You could do the same for other fields.
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.