Tom van Enckevort tomvanenckevort

## umbraco v7 db cleanup.sql
-- Umbraco Clear Old Document Versions To Decrease Database Size And Improve Performance
-- http://borism.net/2008/12/16/fixing-a-large-cmspropertydata-table-in-umbraco/
DECLARE @createdDate Datetime = DATEADD(m, -1, getdate())

-- dump logs
-- TRUNCATE TABLE umbracolog -- faster if log table is very big and you don't need anything
DELETE FROM umbracolog WHERE Datestamp < @createdDate

-- clean up old versions
DELETE FROM cmsPropertyData WHERE

## 00 - Umbraco Automatic Upgrade.md

      
        
          
            
              
              3 files
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                tomvanenckevort
                / 00 - Umbraco Automatic Upgrade.md
            
            
              Last active
              November 1, 2018 10:28
            
              
                Automatic Umbraco upgrade module.
              
          
        
      
        
  
      
    Will automatically execute a pending Umbraco upgrade on startup without prompting the user.
	-- Umbraco Clear Old Document Versions To Decrease Database Size And Improve Performance
	-- http://borism.net/2008/12/16/fixing-a-large-cmspropertydata-table-in-umbraco/
	DECLARE @createdDate Datetime = DATEADD(m, -1, getdate())

	-- dump logs
	-- TRUNCATE TABLE umbracolog -- faster if log table is very big and you don't need anything
	DELETE FROM umbracolog WHERE Datestamp < @createdDate

	-- clean up old versions
	DELETE FROM cmsPropertyData WHERE