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.
here’s my script and when i execute i dont see any output
$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 $Userpermissions = "$_" | out-file C:\users\outputuser.sql
Could someone point me in right direction ? thanks in advance