I have written an app that programmatically creates content nodes of a particular docType in umbraco. I now need to delete approximately 30,000 nodes and recreate them. Ideally, I would just like to run an SQL statement to delete them from the DB. Does anyone have an sql statement to do this?
I was considering using an API call, however I would like to avoid the trash can all together.
Deleting 30k+ content nodes
I have written an app that programmatically creates content nodes of a particular docType in umbraco. I now need to delete approximately 30,000 nodes and recreate them. Ideally, I would just like to run an SQL statement to delete them from the DB. Does anyone have an sql statement to do this?
I was considering using an API call, however I would like to avoid the trash can all together.
Thanks,
Aaron
is working on a reply...