Demo SQL Provider Code

Demo SQL Provider Code

Rate This
  • Comments 17

Hi,

Attached is the code we used today in the Web cast for the SQL demo provider. Please note this is not a SQL management provider. It simply allows you to query data from a SQL server directly from the cmd line.

Install the Snapin: 

PS>$env:Windir\Microsoft.NET\Framework\v2.0\.50727\InstallUtil.exe SQLProvider.dll

Add the snapin to your session:

PS>Add-PsSnapin SqlPrototypeProvider

You can use it as follows:

PS>cd SQL:

SQL:>cd MySQLServer

SQL:>dir

master
tempdb
model
msdb
pubs
Northwind

SQL:>cd Northwind

SQL:>dir

name
----
Categories
CustomerCustomerDemo
CustomerDemographics
Customers
dtproperties
Employees
EmployeeTerritories
Order Details
Orders
Products
Region
Shippers
Suppliers
Territories

SQL:>cd Employees

SQL:>Dir -filter {where EmployeeId=8}

EmployeeID      : 8
LastName        : Callahan
FirstName       : Laura
Title           : Inside Sales Coordinator
TitleOfCourtesy : Ms.
BirthDate       : 1/9/1958 12:00:00 AM
HireDate        : 3/5/1994 12:00:00 AM
Address         : 4726 - 11th Ave. N.E.
City            : Seattle
Region          : WA
PostalCode      : 98105
Country         : USA
HomePhone       : (206) 555-1189
Extension       : 2344
Photo           : {21, 28, 47, 0...}
Notes           : Laura received a BA in psychology from the University of Washington.  She has also completed a course
                   in business French.  She reads and writes French.
ReportsTo       : 2
PhotoPath       : http://accweb/emmployees/davolio.bmp

 Wassim [MSFT]

 

 

Attachment: SQLProvider.zip
Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post
  • Demo SQL Provider Code PowerShellを利用して、SQL Serverのデータベースの中身をまるでフォルダやファイルをたどるようにして見ることのできるサンプルプロバイダのコードが提供されています。こんなことできるんですねぇ。。。...

  • Hello folks!

    I just downloaded the provider and installed it. No errors.

    Then I tried to add-pssnapin and powershell came back telling me, there are no snap ins in version 1.0.

    What's going wrong?

    Cheers!

    quax

  • Great, but ...

    1) Guess, there's a surplus backslash in your cmd line? IMHO it should read: ...\v2.0.50727\...

    2) How do I connect using SQL Authentication?

    JensG

  • There is a bug in the first line of script:

    It should be:

    PS>. $env:Windir\Microsoft.NET\Framework\v2.0.50727\InstallUtil.exe SQLProvider.dll

    Note the "." before the path and the removal of the directory in the Framework version directory.

    Cool entry though.

    John

  • What webcast was this?  I try to join them all...

  • Windows PowerShell用Demo SQL Provider公開(Web castでのDemo用)

  • quax, if you are using x64 you have to use the correct framework.

    Windows\Microsoft.NET\Framework64\v2.0.50727\InstallUtil.exe

  • Marco,

    Event Name: TechNet Webcast: Windows PowerShell in Windows Server 2008 (Level 200)

    Start Date: 6/20/2007

    Start Time: 1:00 PM (GMT-08:00) Pacific Time (US & Canada)

    Please click on the following link for more information regarding this Event https://msevents.microsoft.com/cui/r.aspx?r=1291248013&c=en-US&t=4.

  • I have SQL Express.  SQL server management studio express says my server name is "NB517949\SQLEXPRESS".  I can't seem to figure out the proper combination to cd into...  Any ideas?  

    (I'm able to use that server name using invoke-sql from PowerGadgets to run stuff against the DB.)

  • Sorry,this entry is written only Japanese. http://blogs.msdn.com/powershell/archive/2007/06/21/demo-sql-provider-code.aspx インストール。このページには「¥v2.0¥.50727¥」て書いてあるけど「¥v2.0.50727¥」の間違いだよね。 エラった。。$env:Windor がよくないの

  • Can the prototype provider be made to connect to a named instance?

    Thanks,

    Chris Leonard

  • Haven't tried it yet, but having a SQL provider ROCKS!  I SO need this.

  • Dopo la SQL Conference ho iniziato a scrivere un provider SQL Server per PowerShell. Per chi non sapesse

  • The SQL provider demo code is very fragile specifically when it comes to parsing the path. the code does not support a named instance as NB517949\SQLEXPRESS. The code takes "NB517949" as Server name and SQLEXPRESS as the data base name.

    The authentication is done on the SQL server. I did not add any credential parameter.

    The installation syntax is wrong in the blog it should read $env:Windir\Microsoft.NET\Framework\v2.0.50727\InstallUtil.exe SQLProvider.dll

    Also on 64 bit machines you need to invoke the correct version of InstallUtil.exe

  • Just curious ... is it possible to access  Views this way?  Because I use views more than tables.

Page 1 of 2 (17 items) 12