Demo SQL Provider Code

PowerShellからデータベースの中身を見る

どっとねっとふぁんBlog — Thu, 21 Jun 2007 07:31:51 GMT

Demo SQL Provider Code PowerShellを利用して、SQL Serverのデータベースの中身をまるでフォルダやファイルをたどるようにして見ることのできるサンプルプロバイダのコードが提供されています。こんなことできるんですねぇ。。。...

re: Demo SQL Provider Code

quax — Thu, 21 Jun 2007 10:07:47 GMT

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

re: Demo SQL Provider Code

JensG — Thu, 21 Jun 2007 10:41:45 GMT

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

re: Demo SQL Provider Code

John — Thu, 21 Jun 2007 13:54:51 GMT

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

re: Demo SQL Provider Code

Marco Shaw — Thu, 21 Jun 2007 14:37:35 GMT

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

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

米田 Blog ( SQL Server MEMO ) — Thu, 21 Jun 2007 14:52:54 GMT

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

re: Demo SQL Provider Code

BSonPosh — Thu, 21 Jun 2007 18:43:25 GMT

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

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

re: Demo SQL Provider Code

Aleksandar — Thu, 21 Jun 2007 18:44:43 GMT

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.

re: Demo SQL Provider Code

Marco Shaw — Fri, 22 Jun 2007 04:07:12 GMT

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.)

[powershell][sql]PowerShellのSQL用プロバイダ

学び、そして考える — Fri, 22 Jun 2007 06:56:38 GMT

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 がよくないの

re: Demo SQL Provider Code

chrisleonard — Fri, 22 Jun 2007 18:22:01 GMT

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

Thanks,

Chris Leonard

re: Demo SQL Provider Code

Mike Schinkel — Fri, 22 Jun 2007 18:48:27 GMT

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

SQL Server Powershell Provider

Impedance Mismatch — Sat, 23 Jun 2007 18:53:35 GMT

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

re: Demo SQL Provider Code

Wassim [MSFT] — Sun, 24 Jun 2007 23:09:26 GMT

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

re: Demo SQL Provider Code

Kumar — Tue, 26 Jun 2007 18:28:42 GMT

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

re: Demo SQL Provider Code

Simon Mourier — Wed, 27 Jun 2007 23:35:47 GMT

Hi Wassim,

Cool code. I was wondering, is there anything similar for browsing an object graph/hierarchy, I mean generically? Say I have a Customer object that has an Orders property. Is there a PowerShell provider that allow me to do, for example:

cd MyModel:

cd Customers

cd "John Doe"

cd Orders

dir *.Paid.*

? I thought this would be generic enough to be available right off the box, but I can't find a way to do it? Should I write my own code for this?

Thanks anyway :-)

re: Demo SQL Provider Code

Jason S — Wed, 01 Aug 2007 18:54:30 GMT

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

how could I add a credential parameter?

Thanks

Jason S