RunAllSQLScripts.ps1

Import-Module dbatools

$scripts = get-childitem "C:\ScriptsToRun\" -Filter *.sql | sort-object Name
$servers = "servername"
$database = "databasename"
    
foreach ($script in $scripts) {
    $OutputFile = $script.directoryname + "\" + $script.basename + ".txt"
    Write-Host $OutputFile
    Invoke-DbaQuery -SqlInstance $servers -File $script.FullName -Database $database -MessagesToOutput | Out-File -FilePath $OutputFile
}