8 votes

SQL Scripts

A set of SQL scripts for performing various tasks that may fail in the back-office.

Use at your own risk!

I have tried to optimize these to the best of my knowledge.  I am no SQL DBA, but have some experience.  Each script has a Select output of what will be deleted, to delete, uncomment the delete statements and comment the select statement.

The scripts:

  • Delete Child Nodes - Deletes all descendants of the specified node.  Can also delete specified node with small alteration.  Useful for emptying the Recycle Bin.
  • Delete Old Versions - Deletes old versions of all documents but keeps the most recent x number or anything newer than a specified date.
  • SQL DBO - Changes the owner of the tables in the database to DBO.
  • Create Missing PropertyData records - This is a unique situation script - If you have a very large site, add a property, the back office may fail to add the property to all the documents.  This script will create those entries.
  • Recover Property Data - We've all done it, deleted the property from the document type editor.. crud, I needed that data..  This SQL Script will recover the specified property data from the ContentXml or PreviewXml
Do you have a sql script to contribute?  email me at   firstname@lastname.com
Do you have a sql script request?  Ask in the forum below.

Screenshots

No current release

Package owner

Casey Neehouse

Casey Neehouse

Casey has 483 karma points

Package Compatibility

This package is compatible with the following versions as reported by community members who have downloaded this package:
Untested or doesn't work on Umbraco Cloud
8.0.x (untested)
7.14.x (untested)
7.13.x (untested)
7.12.x (untested)
7.11.x (untested)
7.10.x (untested)
7.9.x (untested)
7.8.x (untested)
7.7.x (untested)
7.6.x (untested)
7.5.x (untested)
7.4.x (untested)
7.3.x (untested)
7.2.x (untested)
7.1.x (untested)
7.0.x (untested)
6.1.x (untested)
6.0.x (untested)

You must login before you can report on package compatibility.

Package Information

  • Package owner: Casey Neehouse
  • Created: 24/07/2013
  • Current version 1.0
  • License MIT
  • Downloads: 3547