Set Compatibility Level for User Databases via Powershell

Scott Newman Powershell, SQL Server March 7, 2013March 7, 2013 1 Minute

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()
	}
}