I've got a dev system with 30,000 plus of page types that I need to periodically delete then reimport. Currently I am clearing down in the UI but it is taking a long time to get them cleared out - deleting from the trash takes a particularly long time.
Does anyone have a quicker way to do this - i was particularly thinking about a SQL clear down script (ran after backing up the DB). Does anyone have such a script that they might be prepared to share - or a few pointers on how to create one. I don't want to go tearing into the database without knowing what i am doing
Many Thanks with any/all help
EPiServer has a few stored procedures that they use internally that might help you, like dbo.editDeletePage or dbo.editDeleteChilds; assuming you those were 30k pages rather than page types.
Thanks I will try to investigate on those lines when i get a moment
Not sure, but may be helpful http://world.episerver.com/Blogs/K-Khan-/Dates/2013/4/EpiServer-CMS-6-Useful-SQL-Queries/