Delete All Umbraco Members by SQL Script

Updated: July 9, 2015

Ali Taheri

Today I had to take the back-up off a live site and restore it on the staging server. However I had to remove all Umbraco members and thought it'd be easier to do that with SQL script than API.

Despite Googling to find a firm solution (SQL script), I couldn't find one, so I decided to share this code in case anyone else wanted to delete all Umbraco members with SQL script rather than API.

This what I have come up with so far, and it seems to have removed all the members, but please leave a comment if you think there is a better way of doing this, or if any other data needs to be removed from any other table.

delete from cmspropertydata where cmsPropertyData.contentNodeId in (select nodeid from cmsMember)
delete from dbo.cmsContentVersion where ContentId in (select nodeId from cmsMember)
delete from dbo.cmsMember2MemberGroup where member in (select nodeId from cmsMember)
delete from cmsContentXml where nodeId in (select nodeId from cmsMember)
delete from cmsPreviewXml where nodeId in (select nodeId from cmsMember)
create table #CmsMemberIds ( nodeId int )
insert into #CmsMemberIds select nodeId from cmsMember
delete from cmsMember
delete from cmsContent where nodeId in (select nodeid from #CmsMemberIds)
delete from dbo.umbracoNode where id in (select nodeId from #CmsMemberIds)
drop table #CmsMemberIds


comments powered by Disqus

© 2017 - Ali Sheikh Taheri