Get-Content -Raw parameter error

Question

I have a PowerShell script that would recursively loop a dir and subdir and run all SQL files inside of it and log the execution in .log files 1 for success and 1 for exceptions. The PowerShell script does what its supposed to do but in the cmd window, I see this error:

Get-Content : A parameter cannot be found that matches parameter name 'Raw'

from this line

$query = Get-Content -Path $_.FullName -Raw

This statement runs within a loop, so FullName changes per iteration. This is the version I use.

Name             : Windows PowerShell ISE Host
Version          : 5.0.10586.117

Sample script goes below:

Get-ChildItem $ScriptFolder -Recurse -Exclude "*Archive*" -Filter *.sql |
  sort Directory |
  ForEach-Object { 
    $query = Get-Content -Path $_.FullName -Raw
    $result = SQLCMD -S $FullDBServer -E -I -Q $query -d $Database

Any thoughts?

Answer 1

The -Raw parameter of Get-Content was introduced in PS3.

To get file contents in one string there are several methods.

• The fastest method that works in any PS version:
  $text = [IO.File]::ReadAllText('c:\path\file.ext')
• The 2 times slower method for PS3+:
  $text = Get-Content 'c:\path\file.ext' -Raw
• The 100 times slower PS2-compatible alternative:
  $text = Get-Content 'c:\path\file.ext' | Out-String
• The 30 times slower PS2-compatible alternative:
  $text = Get-Content 'c:\path\file.ext' -ReadCount 1000 | Out-String