Does anyone have a script to mass delete people in the system? I would prefer to use Arena's 'delete' option but I think that only works per record. I just need to make sure everything gets deleted that is tied to a person.
The connection is the other direction, you cannot mass delete records in SQL if the person has certain types of data connected to the record.
I would recommend mass merging people as an easier and faster solution. Instead.
Create a fake person record to keep permanently, and merge five or so records into it at a time.
I like the idea but I am talking like 45,000 records... on my development site of course :-) I think that would halt the system! If not the merge, can I get all the tables involved so I can write a script to do the delete? I can go through and basically test but if there is a list somewhere that would save me time.