I've got a some large stored procedures that I've split up into separate files within a subfolder, this script combines them into a single file

Build_Script

$dir = 'C:\svn\SQL'
$dirs = Get-ChildItem -Path $dir –Directory

Foreach ($dir in $dirs) {
    
    $files = Get-ChildItem $dir.FullName -Filter *.sql
 
    Foreach ($file in $files) {
        $combinedFile = $combinedFile + (Get-Content $file.FullName)
    }
    $combinedFile | Set-Content ($dir.FullName + '.sql')
}