Sql Server Powershell

Set Compatibility Level for User Databases via Powershell

,

Quick script to set the compatibility level for all user databases from 100 (sql 2008) to 110 (sql 2012) via powershell.  This uses SQLPSX.

Import-Module SqlServer

Get-SqlDatabase -sqlserver 'ServerInstance' | where{$_.IsSystemObject -eq $false} |%{
	
	if($_.CompatibilityLevel -eq [Microsoft.SqlServer.Management.Smo.CompatibilityLevel]::Version100)
	{
		$_.CompatibilityLevel = [Microsoft.SqlServer.Management.Smo.CompatibilityLevel]::Version110
		$_.Alter()
	}
}

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.