如何通过PowerShell连接本地SQL server 2016并执行存储在.sql文件中的SQL？

$serverName = "localhost"  # SQL Server实例名称
$databaseName = "YourDatabase"  # 数据库名称
$connectionString = "Server=$serverName;Database=$databaseName;Integrated Security=True;"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

$sqlFilePath = "C:\path\to\your\sql\file.sql"  # .sql文件的路径
$sqlQuery = Get-Content -Path $sqlFilePath | Out-String
$command = New-Object System.Data.SqlClient.SqlCommand($sqlQuery, $connection)
$command.ExecuteNonQuery()

$connection.Close()