Sunday, August 27, 2017

Powershel to read TSQL

function sql($sqlText, $database = "master", $server = ".")
{
    $connection = new-object System.Data.SqlClient.SQLConnection("Data Source=$server;Integrated Security=SSPI;Initial Catalog=$database");
    $cmd = new-object System.Data.SqlClient.SqlCommand($sqlText, $connection);

    $connection.Open();
    $reader = $cmd.ExecuteReader()

    $results = @()
    while ($reader.Read())
    {
        $row = @{}
        for ($i = 0; $i -lt $reader.FieldCount; $i++)
        {
           # $row[$reader.GetName($i)] = $reader.GetValue($i)

           write-host $reader.GetValue($i)



        }
        $results += new-object psobject -property $row          
    }
    $connection.Close();

    $results
}



$squery =Get-Content "e:\pws\Drivespace1.sql"
write-host $squery
sql $squery "master" "WIN-SHFP3JMVG4E\SQLSERVER3"

No comments:

Post a Comment