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.
You can dowload the source of the Content Maintenance Dashboard package. It queries the database using sql and then tweek the code a bit to delete the document also from recyle bin
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
You can dowload the source of the Content Maintenance Dashboard package. It queries the database using sql and then tweek the code a bit to delete the document also from recyle bin
Or follow the instructions in this post (make a backup)
Cheers,
Richard
is working on a reply...