Hi All,
I have a site with roughly 400k members and about 200k content nodes in the database.
I want to give the developers a local copy of the database, with the content data, but without the members.
My approach in the past was to export the entire database, import it locally, then run a piece of code that deleted the members one at a time. It took the bones of 3 days to delete all the members on quite a beefy machine.
Another option I have is to export the content with usync, set up a new database locally and import the content. But I get the feeling that 200k content nodes will take equally as long.
So, I wonder is there a way of quickly deleting the member records, using SQL? I have seen others ask similar questions for older versions of Umbraco, but I have not seen any suggestions for V10.
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/109860-delete-members-quickly-in-v1000