title: SQLServerCentral Article on Getting Data out of SQL Server from Powershell link: http://sev17.com/2009/01/01/sqlservercentral-article-on-getting-data-out-of-sql-server-from-powershell/ author: Chad Miller description: post_id: 9934 created: 2009/01/01 23:22:00 created_gmt: 2009/01/02 03:22:00 comment_status: open post_name: sqlservercentral-article-on-getting-data-out-of-sql-server-from-powershell status: publish post_type: post

SQLServerCentral Article on Getting Data out of SQL Server from Powershell

Using ADO.NET from Powershell has been covered by several articles, blog entries, and discussion group postings; however alternatives methods have not been as widely written about. The article, Getting Data out of SQL Server from Powershell demonstrates three alternative methods to ADO.NET for querying SQL Server from Powershell. The approaches demonstrated are simplier than ADO.NET and include:

  1. SMO ExecuteWithResults
  2. SQL Server 2008 Powershell Cmdlet Invoke-SqlCmd
  3. CodePlex SQL Server Powershell Extensions function Get-SqlData See the full article for details.