title: execute .sql file using powershell and store the output in a text file
body: <p>I’m trying to run the sql script .sql file from powershell and save the result into .sql file.
  Overview : SQL database restore requires a user and permission backup pre-restore and once the restore is complete we need to execute the output( users permissions backup which we did pre-restore ) on the database.</p>
  
  <p>here’s my script and when i execute i dont see any output</p>
  
  <pre><code>$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
  $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
  $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
  $DataSet = New-Object System.Data.DataSet
  $MyQuery = get-content “C:\Users\Security.sql”;
  $SqlConnection.ConnectionString = “Server = DBATest; Database = Testdb; Integrated   Security = True”
  $SqlCmd.CommandText = $MyQuery;
  $SqlCmd.Connection = $SqlConnection
  $SqlAdapter.SelectCommand = $SqlCmd
  $SqlAdapter.Fill($DataSet)|out-null
  $DataSet.Tables[0] | out-file C:\users\outputuser.sql
  </code></pre>
  
  <p>Could someone point me in right direction ? thanks in advance</p>