如何使用Powershell比较两个SQL表并获得差异值

Get-Module -ListAvailable -Name SqlServer

Install-Module -Name SqlServer

# 导入SQL Server模块
Import-Module -Name SqlServer

# 连接到SQL Server数据库
$connectionString = "Server=<服务器名称>;Database=<数据库名称>;Integrated Security=SSPI;"
$connection = New-Object -TypeName System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

# 比较两个表的差异
$command = $connection.CreateCommand()
$command.CommandText = @"
SELECT * FROM Table1
EXCEPT
SELECT * FROM Table2
"@
$diffResult = $command.ExecuteReader()

# 输出差异值
while ($diffResult.Read()) {
    for ($i = 0; $i -lt $diffResult.FieldCount; $i++) {
        Write-Output $diffResult.GetValue($i)
    }
}

# 关闭连接
$connection.Close()