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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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