SQL Server and Powershell...

  • Article

Two excellent articles giving samples on how to use SQL Server with PowerShell :

Here a part of it :

 #build_exibitors_view.ps1
#This script will recreate the 'exhibitors' view in all child databases

$cn = new-object system.data.SqlClient.SqlConnection("Data Source= MyServer\MyInstance;Integrated Security=TRUE;Initial Catalog=Global");
$ds = new-object "System.Data.DataSet" "dsChildSites"
$q = "SELECT [childShowID]"
$q = $q + "      ,[parentDBName]"
$q = $q + "      ,[childDBName]"
$q = $q + "  FROM [Global].[dbo].[ParentChild]"
$da = new-object "System.Data.SqlClient.SqlDataAdapter" ($q, $cn)
$da.Fill($ds)

image