Getting Data out of SQL Server from Powershell

Question

Getting Data out of SQL Server from Powershell

cmille19

SSCertifiable

Points: 5970
More actions
January 1, 2009 at 8:52 pm

#126695

Comments posted to this topic are about the item Getting Data out of SQL Server from Powershell

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Factor SSC-Insane Points: 20244 More actions · Answer 1

Is the SMO library freely-distributable? What would happen if you created a Powershell application using SMO, and then wanted to install it on a computer that didn't have SSMS on it? It would seem a reasonable thing to want to do.

Best wishes,
Phil Factor

cmille19 SSCertifiable Points: 5970 More actions · Answer 2

Phil Factor (1/2/2009)
Is the SMO library freely-distributable? What would happen if you created a Powershell application using SMO, and then wanted to install it on a computer that didn't have SSMS on it? It would seem a reasonable thing to want to do.

Yes, SMO is redistributable and is available as a separate installation outside of SQL Server Management Studio (SSMS):

kozloski SSC Eights! Points: 804 More actions · Answer 3

It appears that the SMO components may be redistributable. The Management Objects package is freely available from Microsoft's site (as part of the Feature Pack for Microsoft SQL Server 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en) or Feature Pack for Microsoft SQL Server 2008 (http://www.microsoft.com/downloads/details.aspx?familyid=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en)

Additionally, there is a blurb contained within the verbiage of the download page which reads:

Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.
Each package indicates the audience(s) for which it was intended, as follows:
Customer: An individual may want to install this for additional licensed functionality such as interoperability.
Partner: An ISV may want to ship this as a redistributable component as part of their application.
Developer: A programmer may want to install this to support application development.

So it looks good for SMO being redistributable.

-- J.Kozloski, MCDBA, MCITP

Phil Factor SSC-Insane Points: 20244 More actions · Answer 4

Thanks both of you for the info. That was very helpful, and makes the SMO solution look very attractive.

Best wishes,
Phil Factor

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 5

Phil Factor (1/2/2009)
Is the SMO library freely-distributable? What would happen if you created a Powershell application using SMO, and then wanted to install it on a computer that didn't have SSMS on it? It would seem a reasonable thing to want to do.

Yes, you can download the management objects separately. You get them from the feature pack downloads for the version you are using. For example, SQL Server 2005 feature packs can be found at: http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Anipaul SSC-Insane Points: 24681 More actions · Answer 6

Anipaul

SSC-Insane

Points: 24681

January 2, 2009 at 10:45 am

#920434

Nice article...:)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 7

Thanks Chad, this is great.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Tom Garth SSCertifiable Points: 6193 More actions · Answer 8

Good article Chad,

You hear about these things and don't have time to look into them, then someone comes along and writes a nice concise article demonstrating a real cool tool.

Thanks,

Tom Garth
Vertical Solutions[/url]

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers